| T O P I C R E V I E W |
| soundofspeed |
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
|
| 6 L A T E S T R E P L I E S (Newest First) |
| soundofspeed |
Posted - 09/14/2018 : 2:03:18 PM
Not a worry, and thanks for the helpful tips Echo!
Have a wonderful weekend. |
| Echo_Chu |
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 |
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 |
Posted - 09/12/2018 : 06:09:01 AM
well, I can get exactly what you want with the option
Echo
Origin Technical Support |
| soundofspeed |
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 |
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 |
