I can't use a help column, because I need to export this as a flat (text
only), fixed length file.


"Peo Sjoblom" wrote:

How about

=TEXT(A1,"@")


in a help column, then copy and paste special over the old values, delete
the help column when everything has been copied over as values and send to
the bank.

Btw, always a good idea to make a backup copy of the raw data before doing
anything like this.

--


Regards,


Peo Sjoblom


"Adam" wrote in message
...
Hi,

I was wondering is there any way to convert currency to a general format
(or
text).
I need to export information from my AP application to my bank. However,
the query comes out of the AP application as a currency field, and the
bank
wants it as text.

1e.
$1,480.67 needs to have the $ , and . stripped out (while retaining the
decimal places) so the bank receives it as 148067

Any help is appreciated.



.