| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Excel format
Why my excel format set a currency as 1.000,00 not 1,000.00 ? Where should i
change the format ? |
|
#2
|
|||
|
|||
|
You may have set your Regional Settings to a European country
that uses that format, or you may have switched comma and period. Windows Start, Settings, Control Panel, Regional Settings, Check General tab that your location is correct i.e. United States Check Number tab that your decimal symbol is a period Check Number tab that your digits grouping is a comma --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Miss Intan" <Miss wrote in message ... Why my excel format set a currency as 1.000,00 not 1,000.00 ? Where should i change the format ? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Imported Date & Time format with calcs. managed in excel from imrp | Excel Worksheet Functions | |||
| Column format when merging Excel data to Word labels | Excel Discussion (Misc queries) | |||
| EXCEL FORMAT PROBLEM WHEN SENDING EXCEL SHEET AS MESSAGE BODY IN . | Excel Discussion (Misc queries) | |||
| How do I unhide the cell format function in Excel 2000 | Excel Worksheet Functions | |||
| Import Indian Rupees as a number format in Excel | Excel Discussion (Misc queries) | |||
Linear Mode
