Win7 and Excel 2007 number formating

[mdelport]

Hi, all

Win7 group separator is a space and format looks 123 456 789.

IN excel I want to format the column with a #,##0.00 (Custom format)
,224.00 format #,##0.00
1246,153.00 format #,##0.00

This works on XP and Excel 2007
224.00 format #,##0.00
1,246,153.00 format #,##0.00


Anybody have a fix except changing the regional setting. Will be a problem each time that I want to change stuff.

 

[TrainableMan]

I don't understand your question. If you are displaying a custom format in excel then what is the problem? Could you maybe display an example of what you are getting and how it is different from what you expect.

In excel it is quite easy for me to display as you indicated but my separator IS already a comma in this country.

 

[Nibiru2012]

Regardless of whether it's Windows 7 or XP, there should be no difference in the way Office 2007 Excel functions.