Need Currency or Decimal Help!

[Jaricketts]

I'm sure this is an easy thing, but I just can't seem to find what I need. I'm importing text to Access, and I have a currency field that has no decimals. I need to add decimals in a fixed position. So for instance, I need 12345 to be 123.45 and 200000 to be 2000.00 So far, I keep getting 12345.00 and 200000.00 I really just a decimal in front of the last two two digits in each cell of the currency column.

Who can give me the 'duh' answer? Choosing currency doesn't seem to work for me.



Thanks!!

[pbaldy]

First thought is to divide by 100, perhaps as part of the import process.

[Jaricketts]

Thanks, I'll try that tomorrow at work!