Custom Cell Format, Zero Pad
 

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

Custom Cell Format, Zero Pad
 

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


"Brandon" wrote in message
...
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




----== Posted via Newsfeeds.Com - Unlimited-Unrestricted-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption =----

Custom Cell Format, Zero Pad
 

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