Comma is not visible in Excel

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

Guest

Ok, this one is weird. I have a user with Office XP SP2, full install of Excel.

When he types in 500000 for instance, no comma appears.

Great, I says to him, I says "That's just a formatting issue."

So, I go to Formatting > Cells and go to the Number category.

Hmm..."Use the 1000 seperator ( )" option is already clicked. Check this out
though, there is no comma in the text description, just like I typed it
above. No comma.

It's like the comma image ain't there, it's been totally blown away.

Any suggestions?
 
Hi

check the settings under start / control panel - regional options ... i'm
using windows xp home and if i go into customized under regional options and
replace the digit grouping symbol (comma) with a space i see the same thing
as what you're describing.

Cheers
JulieD
 
You must log in or register to reply here.

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

Formatting in formulas not allowed before commas 5
Save as CSV not saving the same from Excel 2007 then in Excel 2003 1
Excel is changing the comma symbol in formulas to a square box ? 2
Change Dots into Commas as Decimal Divider 2
Saving text with commas in a .csv file then converting to a .txt f 3
How to switch two data cells ? 5
Excel VBA - Force 4 commas into a text field on userform 7
Excel should warn about commas when saving .csv files. 1

Back
Top