Adding 0 to the front of a number
 

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!

Adding 0 to the front of a number
 

Hi,

Apply a custom format of 00000
That's 5 zeroes.

Mike

"Staten42" wrote:

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!

Adding 0 to the front of a number
 

Format cellsCustom 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
---------------
Jacob Skaria


"Staten42" wrote:

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!

Adding 0 to the front of a number
 

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

"Jacob Skaria" wrote:

Format cellsCustom 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
---------------
Jacob Skaria


"Staten42" wrote:

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!

Adding 0 to the front of a number
 

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

If this post helps click Yes
---------------
Jacob Skaria


"Staten42" wrote:

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

"Jacob Skaria" wrote:

Format cellsCustom 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
---------------
Jacob Skaria


"Staten42" wrote:

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!