Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
DrNASA
 
Posts: n/a
Default Comma is not visible in Excel

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?
  #2   Report Post  
JulieD
 
Posts: n/a
Default

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

"DrNASA" (donotspam). wrote in message
...
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?



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
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
I get a program error when I download an excel template Ladybug Excel Discussion (Misc queries) 3 March 4th 05 12:02 AM
Difference in number of Excel NewsGroups Hari Prasadh Excel Discussion (Misc queries) 1 January 25th 05 11:32 AM
save an Excel worksheet as a comma delimited file? Trophy Man Excel Discussion (Misc queries) 2 January 8th 05 03:11 AM
How do I update Excel 2000 macros to work in Excel 2002? BobPetrich Excel Discussion (Misc queries) 3 January 4th 05 04:06 PM


All times are GMT +1. The time now is 12:07 AM.

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"