Getting zeros to remain in a numbers column.

[Hswift]

Hello,

I’m importing a column of numbers that appear like this in its original file

numberscolumn


167847651
000000065
000000646

However, the column looks like this after I have imported it into Access

numberscolumn
16784765
65
646

How can I get the zeros to remain in Access like they do in the original file?

Thanks!

[June7]

Are you importing to an existing table? Is the field set up as text type?

[Hswift]

I am not importing to an existing table. I can setup the field to be anything you think is best.

[June7]

It must be text type to retain the zeros. Otherwise, will have use a calculation in query or textbox to force display of leading zeros.

[Hswift]

Thanks! that fixed it.

[CJ_London]

or just format the numeric value

format(myNumber,"000000000")