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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
format cell to show leading zeros and make cell a three digit fiel
try custom formatting as 000
-- Don Guillett SalesAid Software "Kristin" wrote in message ... 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! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
format cell to show leading zeros and make cell a three digit fiel
Custom format of 000
You will still have a 1 digit entry that looks like 3 digits. You cannot actually have an entry like 002 unless it is text. A formula.....=TEXT(A1,"000") Gord Dibben MS Excel MVP On Fri, 28 Jul 2006 08:28:01 -0700, Kristin wrote: 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! |
Reply |
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) |