Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
chiuam
 
Posts: n/a
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.misc
Anne Troy
 
Posts: n/a
Default 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?



  #3   Report Post  
Posted to microsoft.public.excel.misc
Chip Pearson
 
Posts: n/a
Default 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?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
number returns only two decimal places after I change from text quale Excel Discussion (Misc queries) 5 December 8th 05 08:22 PM
Change FORMAT viddom Excel Discussion (Misc queries) 1 July 1st 05 06:06 PM
Cell Change Color - Need Help alani New Users to Excel 3 June 29th 05 03:50 PM
change cell shading whenever contents different from previous cell zooeyhallne Excel Discussion (Misc queries) 3 June 6th 05 09:59 PM
How can I change decimal amounts to end with .95 naclu Excel Worksheet Functions 2 January 11th 05 05:58 PM


All times are GMT +1. The time now is 07:55 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"