converting db need six digit w leading zeros,

E

eStreet4ever

I need to have a six digit value for an ID field. Old db has values ranging
from one to four characters and need to front fill with zeros
 
J

Jacob Skaria

If this is just for display purpose then custom format the cells to 000000

The below will return the value as text and not numeric...
=TEXT(A1,"000000")
 

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

Leading Zeros in Numeric Values 6
vlookup returning zeros 5
Embedded Dec2hex help needed 2
Convert stored numbers into a set naming convention 4
format cell to show leading zeros and make cell a three digit fiel 2
Replacing special characters in Excel 2007 3
How do I stop Excel from dropping leading zeros? 9
Adding 0 to the front of a number 4

Top