leading zeros
thanks. that worked.
"Sloth" wrote:
use a custom number format of 0000
"P. Zicari" wrote:
I am creating a column of passwords some of which need to begin with a zero.
When I move to a new cell it automatically drops the initial zero and is
making my 4 digit password 3 numbers. Is tehre a way to keep it set as a
number not text and still elt it hold the inital 0? I am using Excel 2002.
Thanks
|