Display 0 first 1-9

[Dibbley247]

Hi

I need to concatenate some cells to produce a lookup.
But the sheet which it looks up. weeks 1-9 start with 0. 01,02,03, and so on.


How can I achieve a weeknum which will display 0 for the first 9 weeks?

Thanks

[Ron Coderre]

A1: a week number.....9
This formula displays formatted text...

Please Login or Register  to view this content.

The result will be text: 09

Is that something you can work with?

[Dibbley247]

Yes it is thanks