| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Entering 6 digit numbers into a cell with zeros at the beginning
I am trying to enter a cheque number in a cell ie 000002, when I move from
the cell it comes up as just "2". Have tried everything in format cells, number ??? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Entering 16 digit numbers in cell | New Users to Excel | |||
| how can a two digit # be set up with 2 0's at the beginning 0025 | Excel Worksheet Functions | |||
| format cell to show leading zeros and make cell a three digit fiel | Excel Worksheet Functions | |||
| csv file drops zeros at beginning of a set of Numbers | Excel Discussion (Misc queries) | |||
| 16 DIGIT NUMBERS IN CELL WITHOUT LAST DIGIT BEING A ZERO | Excel Worksheet Functions | |||
Threaded Mode
