If I have an amount of $2.00 how can I display this in another field as 200, $200.00 to equal 20000
I've tried filtering and i lose the zero's at the end ?
It sounds like the field is a number field that has formatting options applied, probably currency formatting.
If you change the formatting to percentage you'll get the correct figure but you'll have a percentage symbol too.
Creating a calculation field that is (100 * amount ) may be the simplest thing to do.
Thanks Malcolm, I did try all sorts of formatting as text etc...but the calculation field works fine, thanks so much.