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!