Convert currency to general
Format to general to remove the currency sign.
Second part I don't understand........remove the , and . but retain the
decimal places.
If you delete the . there are no decimal places.
Try this...........................
Enter 100 in an empty cell.
Copy that cell.
Select the range to change and Paste SpecialMultiplyOKEsc.
Returns 148067
Gord Dibben MS Excel MVP
On Mon, 9 Nov 2009 13:24:01 -0800, Adam
wrote:
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.
|