ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Adding new 'Type' to Format->Number->Time->Type (https://www.excelbanter.com/excel-discussion-misc-queries/47278-adding-new-type-format-%3Enumber-%3Etime-%3Etype.html)

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


"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







Chip Pearson

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







Myrna Larson

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?

Alex Vinokur

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





Alex Vinokur


"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





Alex Vinokur


"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












All times are GMT +1. The time now is 02:38 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com