G
Guest
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.
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.