How do I change the way the decimal separator displays?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Decimal point in bar chart and similar 1
Decimal dot to Decimal Comma 3
Combobox changes the decimal commas to dots - How to prevent it? 2
Decimal Points and comma separators 2
Importing txt-file with "." (= dot) as decimal separator doesn't w 2
Use commas as decimal separator 2
How to change default value of comma style 1
Numbers change to dates automatically 3

Back
Top