Custom Cell Format, Zero Pad

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
 
V

Vergel Adriano

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")
 
G

Guest

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

Concatenate Numers / Text (Special) 2
Conditional format lowest value greater than zero and copy formula 2
Interesting Custom Format Problem 2
Excel Format Question -- CC:SS treated as time HH:mm 2
Time format 10
Custom Number Format for text 8
Concatenate custom cells 5
Addiing a Zero to a number which is already there 1

Top