Format Formula Results with Leading Zeros

[NSG185]

I have a lookup formula that is returning values to include in a part number. The value that comes up might be "2103" or "5242698" but I need them all to be formatted with 8 digits so I want the appropriate amnt. of 0s to be added.

i.e.
Formula Value / Required Format
2103 = 00002103
5242698 = 05242698

Thanks for your help.

 

[GlennUK]

If you want them to be text values then do;
=TEXT(lookup_formula,"00000000")

 

[lenze]

=TEXT(Your Lookup Formula,"00000000")

lenze

 

[Richard Schollar]

Hi

You didn't mention what your lookup formula was, but assuming it is a vlookup, just wrap it in the TEXT() function:

=TEXT(YourLookupFormula,"00000000")

 

[NSG185]

Wow- that was fast. Thanks to you everyone for the help.