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 ?