Enter 1000 in a cell.

Copy that cell

Select you range of money data and paste specialdivideokesc

Delete the 1000 cell.

Gord



On Tue, 26 Aug 2014 13:45:58 +0100, IpswichBlues
wrote:


I need to convert a column of money data into a format that is
recognized by QuickBooks Online so I can upload bank account
transactions. I am in Tunisia where the bank gives us the data in a bad
format that needs to be converted.

The money data looks like this.
Amount
-565,000
-400,645
-5,000

This needs to look like
Amount
-565.000
-400.645
-5.000

I thought I could easily change the "," to an "." but the "," is not
actually in the field as as excel thinks its the thousand character.
Also thought I could use LEFT and RIGHT but the LEFT numbers are always
different. The RIGHT numbers will always be 3 though as Tunisian Dinar
is thousandth of a DINAR.

Hope I am making sense and that someone can help.
thanks in advance.