| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
custom cell
i want to be able to just put in 2 numbers instead of 6 each time. How can i
custom a cell to be able to put 00-00000 ? i tried to use the 000"-00-000" put it would not work for the above. any suggestions? thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
custom cell
DId you mean 00-0000 or 00.0000??
"Renee'" wrote: i want to be able to just put in 2 numbers instead of 6 each time. How can i custom a cell to be able to put 00-00000 ? i tried to use the 000"-00-000" put it would not work for the above. any suggestions? thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
custom cell
try doing format/cell then in the category choose Custom and type in the
following 00-00000 when you enter 1234567 , it will show as 12-34567 "Renee'" wrote: i want to be able to just put in 2 numbers instead of 6 each time. How can i custom a cell to be able to put 00-00000 ? i tried to use the 000"-00-000" put it would not work for the above. any suggestions? thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custom Cell Format - Please help! | Excel Discussion (Misc queries) | |||
| Custom Cell Formats | Excel Discussion (Misc queries) | |||
| Custom format that shows blank cell if another cell is empty | Excel Discussion (Misc queries) | |||
| Send cell value to custom pane based on current cell/row? | Excel Discussion (Misc queries) | |||
| custom a cell | Excel Discussion (Misc queries) | |||
Linear Mode
