Number Format
 

I want to format some cells in the accounting mode, I used 2 decimal places.
One of the numbers is $4,508.46. If I use that format I get $450,846.00. What
can I do so that I do not have to do it manually?

Thank you in advance

Number Format
 

What are your decimal and thousand separators?

You have to swap , and .

You can search and replace . by ^
then search and replace , by . and finally
search and replace ^ by ,

If this does not work then do it the other way
, by ^
.. by ,
^ by .
"aarmpa" wrote:

I want to format some cells in the accounting mode, I used 2 decimal places.
One of the numbers is $4,508.46. If I use that format I get $450,846.00. What
can I do so that I do not have to do it manually?

Thank you in advance