Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Chip Pearson
 
Posts: n/a
Default

No, you can't add a new type there. You can add new types in the
Custom category.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Alex Vinokur" wrote in message
...
Format-Number-Time-Type.

Can one add new type here?
If it possible, how to do that?

--
Alex Vinokur
email: alex DOT vinokur AT gmail DOT com
http://mathforum.org/library/view/10978.html
http://sourceforge.net/users/alexvn






  #2   Report Post  
Chip Pearson
 
Posts: n/a
Default

Select 'Custom' in the Category list and enter your number format
'Type' text box.





"Alex Vinokur" wrote in message
...

"Chip Pearson" wrote in message
...
No, you can't add a new type there. You can add new types in
the
Custom category.

[snip]

Ho to do that?


--
Alex Vinokur
email: alex DOT vinokur AT gmail DOT com
http://mathforum.org/library/view/10978.html
http://sourceforge.net/users/alexvn






  #3   Report Post  
Myrna Larson
 
Posts: n/a
Default

Who knows? The fact that it isn't included in the list doesnt preclude you
from adding it as a custom format.

On Mon, 26 Sep 2005 21:45:28 +0200, "Alex Vinokur"
wrote:


"Alex Vinokur" wrote in message

...
Format-Number-Time-Type.

Must be as follows:
Format-Cells-Number-Time-Type
[snip]

I am working with two different Excell versions.
First version contains type hh:mm:ss where hh 24.
Second version doesn't contain such a type. What is reason for missing that

type in second version?
  #4   Report Post  
Alex Vinokur
 
Posts: n/a
Default Adding new 'Type' to Format->Number->Time->Type

Format-Number-Time-Type.

Can one add new type here?
If it possible, how to do that?

--
Alex Vinokur
email: alex DOT vinokur AT gmail DOT com
http://mathforum.org/library/view/10978.html
http://sourceforge.net/users/alexvn




  #5   Report Post  
Alex Vinokur
 
Posts: n/a
Default


"Chip Pearson" wrote in message ...
No, you can't add a new type there. You can add new types in the
Custom category.

[snip]

Ho to do that?


--
Alex Vinokur
email: alex DOT vinokur AT gmail DOT com
http://mathforum.org/library/view/10978.html
http://sourceforge.net/users/alexvn






  #6   Report Post  
Alex Vinokur
 
Posts: n/a
Default


"Alex Vinokur" wrote in message ...
Format-Number-Time-Type.

Must be as follows:
Format-Cells-Number-Time-Type
[snip]

I am working with two different Excell versions.
First version contains type hh:mm:ss where hh 24.
Second version doesn't contain such a type. What is reason for missing that type in second version?


--
Alex Vinokur
email: alex DOT vinokur AT gmail DOT com
http://mathforum.org/library/view/10978.html
http://sourceforge.net/users/alexvn










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
Adding in another conditional format on the same cell Kelly Lim Excel Discussion (Misc queries) 4 May 23rd 05 09:38 AM
Can I set the numerical type of Cell to Hex format hon123456 Excel Discussion (Misc queries) 2 January 13th 05 02:01 PM
how can i type the numbers in arabic or farsi format مثل 1233 zari Excel Discussion (Misc queries) 0 January 4th 05 06:37 AM
adding military time format am6160 Excel Discussion (Misc queries) 2 December 28th 04 09:41 PM
time format and adding tiome values. dave m Excel Worksheet Functions 3 November 20th 04 08:55 AM


All times are GMT +1. The time now is 09:08 AM.

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

About Us

"It's about Microsoft Excel"