Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 58
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 12
Default 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 =----
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,058
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Custom Cell format to mimic time format [email protected] Excel Discussion (Misc queries) 6 November 7th 06 10:17 PM
Custom Format Cell nastech Excel Discussion (Misc queries) 13 April 28th 06 09:31 PM
Format a cell with a custom number format Armor Excel Worksheet Functions 4 January 30th 06 12:25 AM
cell custom format mark kubicki Excel Worksheet Functions 1 August 25th 05 03:59 AM
Custom Cell Format SimonW Excel Worksheet Functions 1 April 8th 05 06:47 PM


All times are GMT +1. The time now is 03:21 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright 2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"