![]() |
![]() |
We are currently migrating this forum over to our HelpSystems domain. Please post all new threads in our new HelpSystems Community Portal. |
![]() |
|
![]() |
AutoMate Discussion | ![]() |
help :
faq :
home
|
||
Latest News:
|
latest topics : statistics |
Topic Title: Excel - Getting Non Formatted Decimal Topic Summary: Created On: 01/11/2018 09:04 AM Status: Read Only |
Linear : Threading : Single : Branch |
![]() |
![]()
|
![]() |
||||||||||
I have an Excel file I am trying to get the plain text value from the cell. The formatted value in the cell is $ 9.6995, however the value when clicking on the cell the plain text I need to get is 9.699459. I need to get this full value out of the file. When telling Automate to use the formatted value I get back 9.6995, if I don't use formatted value I get back $ 9.6995.
Can someone help me get the full plain text value I expect?
Task Steps: (Right click, Select All, Copy to copy to the clipboard. Steps can then be pasted into the AutoMate Task Builder) |
||||||||||
|
||||||||||
![]() |
||||||||||
Hi Lauren,
I found using the OpenDocument action instead of the Excel action returned the whole price. Please give this a try.
Task Steps: (Right click, Select All, Copy to copy to the clipboard. Steps can then be pasted into the AutoMate Task Builder) ------------------------- ![]() Devin Cannon | Support Analyst AutoMate | Division of HelpSystems HelpSystems, LLC | T: +1.213.738.1700 | F: +1.213.738.7665 |
||||||||||
|
AutoMate Discussion
» AUTOMATE » AutoMate 10
»
Excel - Getting Non Formatted Decimal
|
![]() |
FuseTalk Enterprise Edition v4.0 - © 1999-2021 FuseTalk Inc. All rights reserved.