Problem with percentage format

[APD]

I have a database with two columns for test scores. I have been experimenting with the field properties and format and now all of my percentages are either 0 or 1. I changed my field to:
Single
Percent
Auto



this has fixed the problem for incoming data, but not for my existing data.

Can anyone help??

[boblarson]

The existing data got rounded due to it being an Integer. It is not recoverable. It will need to be re-entered.

[APD]

Thank you for your response Bob,

I was expecting that would be the case, I just figured I would try before I start over......lucky for me this is a practice run on a database that I will be creating for work.