![]() |
Excel format
Why my excel format set a currency as 1.000,00 not 1,000.00 ? Where should i
change the format ? |
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