| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel column
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Saving Conditional Formatting in Excel 2007 | Excel Discussion (Misc queries) | |||
| Formatting shapes with excel 2007 | Excel Discussion (Misc queries) | |||
| Conditional Formatting: Excel 2003 vs. 2007 | Excel Worksheet Functions | |||
| Excel 2007 Conditional Formatting barely works | Excel Discussion (Misc queries) | |||
| Conditional Formatting in Excel 2007 | Excel Discussion (Misc queries) | |||
Hybrid Mode
