| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
number input
If you want the numbers to be treated as numbers not text,
format the cell first to have custom format of 00000 On Thu, 03 Aug 2006 17:10:02 +0100, dennisp wrote: Wht is it that Excel does not accept a zero as the first number of a 5 digit zip code? How do you get Excel to accept it? -- Steve (3) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| input box | Excel Discussion (Misc queries) | |||
| Function or number depending on input | Excel Worksheet Functions | |||
| Change color of cell after user has input a number | Excel Discussion (Misc queries) | |||
| Need number of Saturdays and number of Sundays between 2 dates | Excel Worksheet Functions | |||
| Multiple worksheet queries | Excel Worksheet Functions | |||
Threaded Mode
