ExcelBanter - how to change this format?

ExcelBanter (https://www.excelbanter.com/)

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

- - how to change this format? (https://www.excelbanter.com/excel-discussion-misc-queries/193692-how-change-format.html)

Sam Diao

how to change this format?

Hi,all
how to change 30.012,00 format to 30,012.00?not in format----cell pls.
any suggestions?
--
THX!

Bob Phillips

how to change this format?

Change your regional setting, from a comma decimal symbol to a comma, and
vice versa for grouping digit symbol.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Sam Diao" wrote in message
...
Hi,all
how to change 30.012,00 format to 30,012.00?not in format----cell
pls.
any suggestions?
--
THX!

All times are GMT +1. The time now is 04:56 AM.