| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell Formatting Query
....and one more thing if possible... sorry...
How do I set the format of a cell so you can always enter a two digit number [i.e 01-09] without it switching automatically to a one digit number? I need to do this without using text or general formats... Thanks again all! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell Formatting Query
Format/ Cells/ Custom:
00 -- David Biddulph "shakey1181" wrote in message ... ...and one more thing if possible... sorry... How do I set the format of a cell so you can always enter a two digit number [i.e 01-09] without it switching automatically to a one digit number? I need to do this without using text or general formats... Thanks again all! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
| Conditional Formatting For A Cell Other Than The One With The Form | Excel Worksheet Functions | |||
| Transfer Cell Formatting for linked cells | Excel Discussion (Misc queries) | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| cell formatting problems | New Users to Excel | |||
Linear Mode
