| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
format cell to show leading zeros and make cell a three digit fiel
I have a field that has a single digit number in it now, like 2. I want to
fornat the field to add 2 leading zero's to make a three digit entry. How do I do this with a formula, withut going thru entire spreadsheet and fomartting the column to be tex and adding the leading zeros cell by cell? Please help! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
| How do I make a number have leading zeros to fill width of cell? | Excel Discussion (Misc queries) | |||
| Spliting a number with leading zeros | Excel Discussion (Misc queries) | |||
Threaded Mode
