Converting text to numeric percentage

[razorking]

I have a table that has values that are data type test, trying to change the data type to percent and am not seeing what I hoped. My values in text look like this:
2.62
5.00
60.00

When I go to design and change data type to number, field size to decimal and format to percent it returns:
262.00%
500.00%
6000.00%

See attached.

Anything I can do to get this to convert easily the way I want?

 

[SOS]

Are you wanting to convert these to numbers permanently or just to use in a report or something? To do permanently just use an update query and set the Update part of the query to be

[YourFieldNameInBrackets]/100

 

[razorking]

SOS,

Got it, sounds good.

Thanks a lot.