counting Row() digits?

[stew]

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

 

[Pete_UK]

Try this:

8+LEN(ROW())

Hope ths helps.

Pete

 

[stew]

Thanks Pete

Does the Job

Stewart

Try this:

8+LEN(ROW())

Hope ths helps.

Pete

 

[Pete_UK]

You're welcome, Stewart - thanks for feeding back.

Pete