Cant Change Number Format

[Ben]

I have to feilds in a table that no mater what number you enter it auto
formats it to the 'thousend' place. I.E. keyed "98" then changes to "9800.00"
It dosn't mater if i have it set to percent, currency, general or any others
on the list. I've pored thre the options menu but can't seem to find out why
this is happinging. This sounds like a duh question but I can't find it for
some reason. Any help would be awsome

Thank you

Ben

 

[Wayne-I-M]

change the number to (format) - it on the box at the bottom of the screen
to General Number
sounds to me me like you have it set to Fixed

 

[Ben]

yes that did seem to fix it, but when I have it set to Percent format. If I
key "98" it should come up "98%" right? not "9800%". I haven't come accross
this prob before.

 

[John W. Vinson]

yes that did seem to fix it, but when I have it set to Percent format. If I
key "98" it should come up "98%" right? not "9800%". I haven't come accross
this prob before.

No. A percentage is A FRACTION - 98% is just a different way of depicting the
number 0.98. The number 98 is indeed 9800%.

 

[BruceM]

To add to what John wrote, a percent is often calculated based on other
values rather than being entered as a standalone value unrelated to other
values. You could use a text box After Update event to divide by 100, which
would give you the correct result.

 

[BruceM]

By "correct result" I mean the number you would like to see.