Thread: Leading zeros
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
mary
 
Posts: n/a
Default Leading zeros

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