Access field with no decimal point

[confuseddddd]

Have created a table that has data coming from a text file with dollar sign, comma and decimal points. I want to be able to just have the field be zero filled and no decimal point but keep the decimal amounts...example have $6,512.31
and want it to be 00000651231...
how can I accomplish that using Microsoft Access???

 

[PHV]

Something like this ?
Format(CCur(txtData) * 100, "00000000000")

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244