Windows 7 Forums


Reply
Thread Tools

Win7 and Excel 2007 number formating

 
 
mdelport mdelport is offline
New Member
Join Date: Mar 2011
Posts: 1
Thanked: 0
 
      03-24-2011
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.
 
Reply With Quote
 
 
 
 
TrainableMan TrainableMan is offline
^ The World's First ^
TrainableMan's Avatar
Join Date: May 2010
Location: PA, USA
Posts: 4,656
Thanked: 887
 
      03-24-2011
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.
Win7 and Excel 2007 number formating-formatcell.jpg
 
Reply With Quote
 
Nibiru2012 Nibiru2012 is offline
Quick Scotty, beam me up!
Nibiru2012's Avatar
Join Date: Oct 2009
Location: Planet X
Posts: 4,852
Thanked: 1073
 
      03-26-2011
Regardless of whether it's Windows 7 or XP, there should be no difference in the way Office 2007 Excel functions.
 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
excel and Win7 Mychael Crashes, BSODs and Debugging 3 10-19-2010 10:19 PM


All times are GMT +1. The time now is 11:21 AM.
W7Forums is an independent website and is not affiliated with Microsoft Corporation.

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33