Custom Cell Format, Zero Pad

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Try "00" as the number format.

For concatenating the numbers, assuming they are in A1, A2, A3:

=TEXT(A1, "00") & "." & TEXT(A2, "00") & "." & TEXT(A3, "00")
 
Format > Cells... > Number > Custom > 00

for the first question

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

for the second
 
Back
Top