Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 =---- |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Custom Cell format to mimic time format | Excel Discussion (Misc queries) | |||
Custom Format Cell | Excel Discussion (Misc queries) | |||
Format a cell with a custom number format | Excel Worksheet Functions | |||
cell custom format | Excel Worksheet Functions | |||
Custom Cell Format | Excel Worksheet Functions |