Convert currency to general
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.
|