Formatting Dollar Amounts

[Guest]

What's the best way to remove the non-numeric characters ($ , .) from a dollar amount, whil preserving the actual dollar amount.
To be specific, I have a field which has dollar amounts of varying lengths (up to 12 characters), which need to be formatted so that just the numbers remain.
The problem I've been running into, is the standard format commands either round the amount up and/or drop the last digit when it is a zero.
For example, I need $156.80 to appear as 15680, and not 157 or 1568.

Thanks.

 

[Mark W.]

This can't be done with formatting. Formatting doesn't alter the internal representation of values. If A1 contains 156.8 formatted as $156.80 you could get your desired value using =A1*100
This message was edited by Mark W. on 2002-03-08 10:01

 

[Tim Francis-Wright]

If all you have is dolalrs and cents, then
you could try

=TEXT(A1*100,"#00")

to get what you want.