converting db need six digit w leading zeros,

  • Thread starter Thread starter eStreet4ever
  • Start date Start date
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
 
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

Convert stored numbers into a set naming convention 4
Leading Zeros in Numeric Values 6
Rounding cents 3
vlookup returning zeros 5
VLOOKUP, a table with text and numerics 7
converting ssn's 12
Function to Count Zip Code Digits With Leading Zero 2
Embedded Dec2hex help needed 2

Back
Top