Muse

Pre-format the cells as text (FormatCells...Text) or prefix with a single
apostrophe ('), this will not show but will retain the leading zero

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS

"muse calliope" <muse wrote in message
...
in the phone number cell and I cant cause by default when I press enter
zero
is omitted