Thread
:
format cell to show leading zeros and make cell a three digit fiel
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Don Guillett
external usenet poster
Posts: 10,124
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!
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett