Then I guess you will have use the multiply by 100 trick before formatting
to no decimals.


Gord

On Fri, 13 Nov 2009 11:28:03 -0800, Adam
wrote:

The bank wants the amount in a fixed length field.

so:
1 = 1Cent
11 = 11 cents
111 = one dollar eleven cents
1111 = eleven dollars eleven cents

So, if I start with a whole alunt like $250.00
and I strip off the decimals leaving 250
The bank will now interpret that as two dollars and fifty cents,

"Gord Dibben" wrote:

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.

.