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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

zeros show as dashes in spreadsheet, want to show 0. 2
Displaying zeros in cells 2
Padding with leading zeros 2
Concatenate Numers / Text (Special) 2
Question about conditional formatting of zeros in Excel 0
Conditional format lowest value greater than zero and copy formula 2
Custom Number Format for text 8
concatenate & custom formats 1

Back
Top