Format Cells... Number Custom 00

for the first question

=TEXT(J1,"00.") & TEXT(J2,"00.") & TEXT(J3,"00.")

for the second
--
Gary''s Student
gsnu200707


"Brandon" wrote:

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