ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel format (https://www.excelbanter.com/excel-discussion-misc-queries/34666-excel-format.html)

Miss Intan

Excel format
 
Why my excel format set a currency as 1.000,00 not 1,000.00 ? Where should i
change the format ?

David McRitchie

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 ?





All times are GMT +1. The time now is 08:31 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com