Win7 and Excel 2007 number formating

Joined
Mar 24, 2011
Messages
1
Reaction score
0
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

^ The World's First ^
Moderator
Joined
May 10, 2010
Messages
9,353
Reaction score
1,587
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.
formatcell.jpg
 

Nibiru2012

Quick Scotty, beam me up!
Joined
Oct 27, 2009
Messages
4,955
Reaction score
1,302
Regardless of whether it's Windows 7 or XP, there should be no difference in the way Office 2007 Excel functions.
 

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

Top