Hi, I know this must be simple but having trouble doing it.

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 ?

Thanks in advance for any help.

Hi, I know this must be simple but having trouble doing it.

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 ?

Thanks in advance for any help.

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.

Malcolm

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.

Malcolm