It is text, formats work on numbers.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"MoJo" wrote in message
...
What format should I use to display 1.1.01 as 1.1.1 in a cell?