in the phone number cell and I cant cause by default when I press enter zero
is omitted

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

Use a custom format or format special phone number

--
Regards,

Peo Sjoblom


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