View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default 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!