Format Column

  • Thread starter Thread starter Morpheseus
  • Start date Start date
M

Morpheseus

I have a column with inmate id numbers in it. I imported them from a
text based program. I made a custom formatting for the column because
all the id numbers begin with zero. IE 00112356 or 01555666 etc...
The format I used was 00000000 under custom.

The problem now is that I want to import them into access but access
doesn't see the zero at the beginning. How can I make it show the
literal number including the zeros? I tried adding the '01222555
before the number, but I would have to manually append 2000 records.
Is there a faster way?

Morph.
 
Thanks Frank! That worked perfectly. I just imorted 1067 records
into my table by using this formula in a help column. Then I just
deleted the original column ... leaving me only the correct formatting
in the final column.

M.
 
Back
Top