View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
SteW SteW is offline
external usenet poster
 
Posts: 293
Default counting Row() digits?

Hi all

In the Calculation below

=IF(RIGHT(B108,10)="Receipt"&" "&ROW()-1

how can I turn the 10 into 11 when the row() goes from 99 to 100
and also 11 into 12 when the row() goes 999 to 1000
etc
etc

Thanks

Stewart