ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Why use comma instead of full stop for displaying value? (https://www.excelbanter.com/excel-discussion-misc-queries/138998-why-use-comma-instead-full-stop-displaying-value.html)

Eric

Why use comma instead of full stop for displaying value?
 
How come the value 8.5% display in execl by comma 8,5% rather than full stop
8.5%?
Does anyone have any suggestions?
Thank you in advance
Eric



Toppers

Why use comma instead of full stop for displaying value?
 
Look at Tools=Options=International

Is "Use System separators" checked? If not, then check it.

If it is, look at Control Panel=Regional and Language Settings as "," is a
European (non-UK) convention.

HTH

"Eric" wrote:

How come the value 8.5% display in execl by comma 8,5% rather than full stop
8.5%?
Does anyone have any suggestions?
Thank you in advance
Eric



Miguel Gamez

Why use comma instead of full stop for displaying value?
 
Same Problem, already checked th 1000 separator and changed the control panel
settings but still 8.543 appears as 8,543; in my case that is a big change
please help

"Toppers" wrote:

Look at Tools=Options=International

Is "Use System separators" checked? If not, then check it.

If it is, look at Control Panel=Regional and Language Settings as "," is a
European (non-UK) convention.

HTH

"Eric" wrote:

How come the value 8.5% display in execl by comma 8,5% rather than full stop
8.5%?
Does anyone have any suggestions?
Thank you in advance
Eric




All times are GMT +1. The time now is 08:22 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com