Adding 0 to the front of a number

S

Staten42

I have a data set that has a 5 digit id field with the first id being 00001.
How can I add the zeros i need to a similar data set that doesn't currently
have the zeros in front to make the 5 digit character?

Any help would be awesome!
 
J

Jacob Skaria

Format cells>Custom> Type: 00000

If you need to combine this with any formulas to reflect the text with 5
digits you can use the below formula
TEXT(A1,"00000")

If this post helps click Yes
 
S

Staten42

Would I need to do that if using the VLOOKUP function to compare the two data
sets?
 
J

Jacob Skaria

If the lookup value and array value is formatted to display 00000 then you
dont need to.

If this post helps click Yes
 

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 sequence numbers to paragraphs 0
Creating a Chart on form from selected data in query. 0
Add a sequence number(question number) to a paragraph which has a question and 4 options and answer 0
Delete all data after a symbol in a field 0
How do I remove the apostrophe(') in front of zeros 3
How add a digit to front of number in each cell in excexl column 1
Truncating Number Series 3
Page numbering with Merged Document and IF statements 1

Top