Leading zeros

G

Guest

How do I retain the leading zeros in an if statement eg if b3=b2 then b4+1
where b4 = 0001. The next number generated should be 0002 not 2.

Thanks
Mary
 
G

Guest

If you set the number format for those cells to be 0000, they'll show the
leading zeros, but they won't actually be part of the value. Meaning that
the number 2 will display as 0002.

They you could use a variation of this formula:
=IF(B2=B3,B4+1,B4)

Alternatively, you could try working with this:
=IF(B2=B3,TEXT(--(B4)+1,"0000"),B4)

Which will actually create "numeric text" but treat it like a number. The
value will be the string 0002, not the number 2.

Something you can work with?

***********
Regards,
Ron

XL2002, WinXP-Pro
 

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

Creating sequential text string of fixed length 6
Stripping leading zeros 2
How to stop Excel from automatically truncating leading zeros 2
Replacing cell numbers but leaving leading zero 1
Add Leading Zeros 4
How do I stop Excel from dropping leading zeros? 9
leading zeros when uploading a number from text file 1
nested ifs 4

Top