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 |
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 |
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? |
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 |
"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" 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