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
|