| Author |
 Topic  |
|
|
soundofspeed
7 Posts |
 Posted - 09/11/2018 : 01:19:31 AM
|
Hi,
I would like to remove the comma for numeric values greater than 1000, but preserve the decimal.
For example....
386899.003
Instead, origin prints it as,
386,899.003
|
Edited by - soundofspeed on 09/11/2018 01:20:24 AM |
|
|
Echo_Chu
China
Posts |
Posted - 09/11/2018 : 06:31:02 AM
|
Hi,
You can choose Separators from the Tools:Options dialog(accessible from menu "Tools:Options")
Echo
OriginLab Technical Service |
 |
|
|
soundofspeed
7 Posts |
Posted - 09/11/2018 : 4:25:41 PM
|
Hi Echo,
Is there a way to have the format without spaces, and to not have a comma as the separator?
This is how it looks with the settings you recommended.
3 725 433,003
I would prefer...
3725433.003
Thanks for the help.
|
|
|
|
Echo_Chu
China
Posts |
Posted - 09/12/2018 : 06:09:01 AM
|
well, I can get exactly what you want with the option
Echo
Origin Technical Support |
|
|
|
soundofspeed
7 Posts |
Posted - 09/12/2018 : 2:50:59 PM
|
Not exactly. You still have a comma instead of a decimal point. Also it is expressed in Sci.not.
When I switch under properties, it formats with spaces and comma. I want no spaces and no comma.
Is this possible? IT is the default format for excel. |
|
|
|
Echo_Chu
China
Posts |
Posted - 09/12/2018 : 11:25:42 PM
|
Hi,
Sorry that I made a mistake in last post.
To show 3725433.003 in numeric notation instead of scientific notation, you can set a higher upper threshold power.
But for the number you want, I can only suggest you use "Windows Settings" in Options dialog, and then adjust the windows setting to get what you want.
And please use Decimal:1000 to in "Column Properties" dialog
 |
|
|
|
soundofspeed
7 Posts |
Posted - 09/14/2018 : 2:03:18 PM
|
Not a worry, and thanks for the helpful tips Echo!
Have a wonderful weekend. |
|
|
| |
Topic |
|
Thousands Comma