| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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
|
|||
|
|||
|
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
|
|||
|
|||
|
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
|
|||
|
|||
|
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
|
|||
|
|||
|
"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
|
|||
|
|||
|
"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 |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding in another conditional format on the same cell | Excel Discussion (Misc queries) | |||
| Can I set the numerical type of Cell to Hex format | Excel Discussion (Misc queries) | |||
| how can i type the numbers in arabic or farsi format مثل 1233 | Excel Discussion (Misc queries) | |||
| adding military time format | Excel Discussion (Misc queries) | |||
| time format and adding tiome values. | Excel Worksheet Functions | |||
Linear Mode
