Missing commas

S

Steve Mock

I have a workstation using Excel 2000. Since installing XP Service Pack 2,
Excel does not show the commas used to show thousands. For example, the
number shows as 47 911 instead of 47,911. Any ideas what would cause this or
how to fix it?
 
R

Rob van Gelder

Could be two places..
1)
In Excel, Tools | Options | International.
Check the Thousands separator.By default this is set to "Use System
Separators"

2)
From Windows Control Panel, Regional and Language Options
Customise if needed.
 

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

Top