| Author |
 Topic  |
|
|
JonasKlim
Lithuania
36 Posts |
 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 |
|
|
Echo_Chu
China
Posts |
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 |
 |
|
|
JonasKlim
Lithuania
36 Posts |
Posted - 11/22/2017 : 05:35:51 AM
|
Hi Echo,
Thank you, it works.
Regards,
Jonas |
|
|
| |
Topic |
|
|
|
Formating columns