G
Guest
I have a field in a table, I tried setting it to Number and format as
Percentage. Set decimal places to 2 and when I enter 2.19%, it changes to
2.00%. Any idea why? I changed decimal places back to Auto, still does it.
Right now it is a text field with the numbers inputed as a text number, like
2.19, etc. But when I tried an update query, like add 0.02% but used 0.02,
it would turn it into 2.1902. I'm not sure what to do exactly?
Thanks
Curtis
Percentage. Set decimal places to 2 and when I enter 2.19%, it changes to
2.00%. Any idea why? I changed decimal places back to Auto, still does it.
Right now it is a text field with the numbers inputed as a text number, like
2.19, etc. But when I tried an update query, like add 0.02% but used 0.02,
it would turn it into 2.1902. I'm not sure what to do exactly?
Thanks
Curtis