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

counting Row() digits?
 

Try this:

8+LEN(ROW())

Hope ths helps.

Pete

On Jan 16, 1:45*pm, stew wrote:
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

counting Row() digits?
 

Thanks Pete

Does the Job

Stewart

"Pete_UK" wrote:

Try this:

8+LEN(ROW())

Hope ths helps.

Pete

On Jan 16, 1:45 pm, stew wrote:
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

counting Row() digits?
 

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

Pete

On Jan 16, 3:19*pm, stew wrote:
Thanks Pete

Does the Job

Stewart