Weird formatting error, (missing comas)

[jc.021286]

Hey all,
I'm having a weird issue with some of my formats. I have no idea why, but my Number, accounting, Comma Style formats now no longer have commas... instead they are replaced with spaces.

Not a big issue except for when I prepare presentations and the likes and it drives my boss up the wall.

Any and all numbers are always displayed with spaces instead of commas.

I tried creating a custom format though end up with "$ ,397.52" "(,397.52)"

If I press ctrl+1 for the shortcut to formats, the number section has the checkbox Use 1000 Separator ( )

I'm using MS Excel 2010, any help with this would be greatly appreciated.

jc

 

[Jerry Sullivan]

Hi JC,

My guess is that your symbol for Thousands Separator got changed in your regional settings. ....or maybe your region got changed somehow.

I found this link that describes how to change this in xl2003. I presume the steps would be similar for xl2010.

http://office.microsoft.com/en-us/e...thousands-and-decimals-HP003089676.aspx?CTT=3

Hope this helps.

 

[jc.021286]

ah that works,

Under Excel 2007 Excel Options, Advanced, there is a Use system separators Thousands separator [ ].

It looks like that would help solve the issue.

Thanks, that link did help a lot,
jc