converting numbers

  • Thread starter Thread starter LJG
  • Start date Start date
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
 
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.
 
Back
Top