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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding recognised Zeros 5
How to count the maximum number flanked by zeros 9
NumberFormat for small non-zero numbers? 2
Zero on the left !!! 7
Convert Number to Text for Index/Match 1
Data needs to be the same length in a field by pre-filling with a 5
function result losing leading zeros 3
Keep Leading Zeros in Concatenation 5

Back
Top