Thread
:
counting Row() digits?
View Single Post
#
1
Posted to microsoft.public.excel.misc
SteW
external usenet poster
Posts: 293
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
Reply With Quote
SteW
View Public Profile
Find all posts by SteW