| T O P I C R E V I E W |
| JonasKlim |
Posted - 11/22/2017 : 04:58:31 AM
Hi,
I want to copy read numbers from text sting and write them into a cell. The numbers read are like "050", "150", etc. I need data in numeric format, like 50, 150 (omitting first 0).
I try to format column for data with command wks.col(E).format= 1;
Still, the numbers are written like text 050, 150, ...
If I make manual formatting (Properties -> Format), the format is "Text & Numeric". After changing to "numeric" I get correct format 50, 150.
How to make the same with script?
Best regards,
Jonas |
| 2 L A T E S T R E P L I E S (Newest First) |
| JonasKlim |
Posted - 11/22/2017 : 05:35:51 AM
Hi Echo,
Thank you, it works.
Regards,
Jonas |
| Echo_Chu |
Posted - 11/22/2017 : 05:10:48 AM
Hi, Jonas
Please use
wks.col5.format=1;
to set the column format, instead of wks.col(E).format= 1
Echo
OriginLab Technical Support |
|
|
