View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Adam Adam is offline
external usenet poster
 
Posts: 287
Default Convert currency to general

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.