excel 2007 number formatting
 

When I select "thousands separator" when fomatting numbers, the result
appears for example as 1,11,111.00 instead of 111,111.00. Please help.


--
egt

excel 2007 number formatting
 

Someone has messed with your Excel setting to use Indian formatting.
Use Format | Style and in the Style Name box open Comma
You should see _-* #,##0.00_-;-* #,##0.00_-;_-* "-"??_-;_-@_-
If not then edit the style to correct it.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"egt" wrote in message
...
When I select "thousands separator" when fomatting numbers, the result
appears for example as 1,11,111.00 instead of 111,111.00. Please help.


--
egt

excel 2007 number formatting
 

Bernard: Problem solved, thanks.

--
egt


"egt" wrote:

When I select "thousands separator" when fomatting numbers, the result
appears for example as 1,11,111.00 instead of 111,111.00. Please help.


--
egt

Excel column
 

Column change

EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com