Percentage Help (in a Field)

[Joseph31]

Hello everyone..

When I try to formate a Number field as a Percentage the number comes out huge?

Example:

Field 1: Formated as a percentage

when I go to type a number like 20 in it comes out 2000% why?

I just need 20%

Joseph

[Lee Smith]

Hi Joseph,

You have to type it in as a decimal i.e. .20 (100% = 1.00).

Lee

[Joseph31]

is there another way?

Joseph

[Lee Smith]

Hi Joseph,

I see you use V7, so there may be a Get Function that will do this for you better.

In v6 and before, we used to do this trick with phone numbers.

It takes two fields, one for entry and one to do the math.

See the attached file as an example.

HTH

Lee

number to decimal.fp5.zip

[bruceR]

That's what percent MEANS. 5/100 == .05 == 5%.

[Joseph31]

great thanks guys...I will give both of them a try...I will get back to you...thank you for the help

Joseph