| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting Numbers to 3 digit,
In a column i have numbers 1 to 999
but I would like to have as 001 to 999, I cannot format as text, becouse another equation finds the higest number (=max(D:D)) from this column. Is there any way, to have the 3 digit format keeping them as numbers? i.e. Col D 001 002 003 004 -- -- 999 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Store numbers starting with zero as 2 digit numbers | Excel Discussion (Misc queries) | |||
| 15+ digit numbers | Excel Worksheet Functions | |||
| what is the minimum numbers set for 4 digit numbers from 0000 to 9 | Excel Discussion (Misc queries) | |||
| 16 digit numbers | Excel Discussion (Misc queries) | |||
| 16 DIGIT NUMBERS IN CELL WITHOUT LAST DIGIT BEING A ZERO | Excel Worksheet Functions | |||
Threaded Mode
