converting text to custom zero

  • Thread starter Thread starter cdavis
  • Start date Start date
C

cdavis

I've done this before but can't duplicate. To apply
leading zeros to an exsisting field. Example if I take a
blank column and format the cell as custom 9 zeros
000000000 and then I type a number it works 000001234

but if a column of number exsisted and i change the
customer format for the column to 000000000. the 1234 with
not change to 000001234.

The original data was text, LTRIM to delete the ' and then
pasted valued and changed to number.

what's the trick, I know I've taked exsisting
text/numbers and inserted zeros. I need to use a a join
property for ACCESS

thank you in advance
 
If you don't get leading zeros it is still text,
try to copy an empty cell, select the "numbers"
and do edit>paste special and check add
 
Back
Top