ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I change the way the decimal separator displays? (https://www.excelbanter.com/excel-discussion-misc-queries/66456-how-do-i-change-way-decimal-separator-displays.html)

chiuam

How do I change the way the decimal separator displays?
 
The decimal separator used to display as a dot and one day changed to a comma
by itself. How can I change it back to a dot?

Anne Troy

How do I change the way the decimal separator displays?
 
Start--Settings--Control Panel, Regional and Language options.
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

"chiuam" wrote in message
...
The decimal separator used to display as a dot and one day changed to a
comma
by itself. How can I change it back to a dot?




Chip Pearson

How do I change the way the decimal separator displays?
 
The first thing to check is Excel's international settings. Go to
the Tools menu, choose Options, then the International tab.
There, ensure that the settings are correct. If that doesn't
work, go to the Windows Start menu, choose Control Panel, the
Regional settings. Ensure the settings there are correct.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"chiuam" wrote in message
...
The decimal separator used to display as a dot and one day
changed to a comma
by itself. How can I change it back to a dot?





All times are GMT +1. The time now is 04:15 AM.

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