Number Format

A

aarmpa

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
 
S

Sheeloo

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 .
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top