Changing last 2 digits to a decimal

[famousb]

Is there a way (which is a stupid way to start because i'm pretty sure there is) to convert the last two digits of a number into two decimal spots?<br>ie.&nbsp;&nbsp;1000 becomes 10.00<br><br>i thought i could do it through the import wizard, but can't seem to figure that out.&nbsp;&nbsp;i'm just as open to code that i can run after the fact.<br><br>thanks. <p>Brian Famous<br><a href=mailto:bfamous@ncdoi.net>bfamous@ncdoi.net</a><br><a href= > </a><br>

 

[elizabeth]

Create a field that is type numeric named Result and set properties to Format = Fixed, Decimal places = 2, then write a query to multiply it by .01 (or divide by 100). Should work whether the input is text or numeric.<br><br>UPDATE Table1 SET Table1.Result = [Table1].[FieldName]*0.01;

 

[famousb]

ok, now that i read your answer i have to vote for myself for having the stupidest question of all time.&nbsp;&nbsp;i guess sometimes the obvious can be overlooked.<br><br>thanks again elizabeth <p>Brian Famous<br><a href=mailto:bfamous@ncdoi.net>bfamous@ncdoi.net</a><br><a href= > </a><br>

 

[elizabeth]

Naw, I think I've got the &quot;stupidest&quot; award all tied up with one of my <i><b>answers<b></i>. <br><br>