how to change this format?

S

Sam Diao

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

Bob Phillips

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)
 
Top