converting numbers

L

LJG

I have a imported a table that has a field of numbers 26799 etc

This number should be read as 267.99 and want to know how I can format the
number to match this. currently when I change it now it changes to 26,799.

I would be happy to simply drop the first 2 characters so it would become
267.

Any ideas would be welcome
 
J

Jeff Boyce

Wouldn't dividing by 100 do it?

If you use a query to convert your raw import data into a final permanent
table, you could do the "divide by 100" conversion.
 
Top