But how to enter first number by just 1 or 001-2007


"Ken Johnson" wrote:


Rao Ratan Singh wrote:
Thank you mam?sir?
Is there any way to enter =IF(E110,B10+1,"") this formula the number could
display like 002-2007 or 002-A

Regards
RRS

Hi RRS,

Try these formulas...

=IF(E110,REPT("0",2-INT(LOG(B10+1)))&B10+1&"-2007","")

=IF(E110,REPT("0",2-INT(LOG(B10+1)))&B10+1&"-A","")

Sir:-) Ken Johnson