Formatting number using 1000, seperator

[howard]

Since upgrading to Windows7, when using the 1000 comma seperator, there is no longer a , seperator, but rather a space between numbers for eg 35269 should look like 35,269 using the 1000 seperator when formatting, it now looks like this on since using Windows7
35 369. Is there a setting I can change, so that there is a comma seprating thousands?

Your assistance will be most appreciated

 

[truskawa]

You can use custom formatting instead of number.

Enter e.g. #,##0
for 35,269

This is first solution i can think of. Hope it satisfies you

 

[Peter_SSs]

Have a look in Start|Control Panel|Region and Language|Additional Settings|Numbers tab
Might be something in there that doesn't look right.

 

[howard]

Hi Guys

I have just gone to Start|Control Panel|Region and Language|Additional Settings|Numbers tab

I see that Windows7, have removed the comma seperator from nunbers and have spaces instead, therefore one cannot format using the, seperator where Windows 7 has been installed

 

[thunder_anger]

Hi Guys

I have just gone to Start|Control Panel|Region and Language|Additional Settings|Numbers tab

I see that Windows7, have removed the comma seperator from nunbers and have spaces instead, therefore one cannot format using the, seperator where Windows 7 has been installed

go to
Start|Control Panel|Region and Language|Additional Settings|Numbers tab

then reset formats
reset button

 

[Peter_SSs]

I see that Windows7, have removed the comma seperator from nunbers and have spaces instead, ..

I'm not sure that Windows 7 has made that change - at least it didn't for me. I guess it could be different if you have a different language version of Excel.

... therefore one cannot format using the, seperator where Windows 7 has been installed

Not so, you have several choices (not necessarily in this order) ..

1. Try resetting the formats as suggested by thunder_anger.

2. Manually change just the 'Digits grouping symbol' in that Control Panel dialog.

3. Use this setting in Excel:

v2010: File|Options|Advanced|Use system separators (uncheck this and enter your preferences)

v2007: Office icon|Excel Options|Advanced|Use system separators (uncheck this and enter your preferences)

v2003-: Tools|Options...|International tab|Use system separators (uncheck this and enter your preferences)

 

[howard]

Hi Peter

Thanks for the help. The formatting is now working perfectly

 

[Peter_SSs]

Hi Peter

Thanks for the help. The formatting is now working perfectly

Which method did you end up using?

 

[howard]

Hi Peter

I used the option below pertaining to Office 2007

v2007: Office icon|Excel Options|Advanced|Use system separators (uncheck this and enter your preferences)

Once again thanks for all the help.