Hello,

I have some cells I would like to display numbers as two significant
integers, i.e.
0 - 00
1 - 01
2 - 02
...
99 - 99

Is there anyway to do this? I tried the format:
0#

But it doesn't work for 0 or when the number entered is greater than 99.

I would also like to take these cell values and concatenate them together as:
##.##.##
I tried the concatenate function, but it removes the leading zeroes.

Any help is much appreciated.
Thanks