Adding new 'Type' to Format->Number->Time->Type

[Chip Pearson]

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

 

[Chip Pearson]

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

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

 

[Myrna Larson]

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

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]

Format->Number->Time->Type.

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

 

[Alex Vinokur]

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]

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?