I am entering my mobile contacts in xl I want to include zero

[muse calliope]

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

[tommyleejones]

type ' before entering the number (for example '0123456789)

[Peo Sjoblom]

Use a custom format or format special phone number

--
Regards,

Peo Sjoblom


"muse calliope" <muse [email protected]> wrote in message
news:[email protected]...
> in the phone number cell and I cant cause by default when I press enter
> zero
> is omitted

[Nick Hodge]

Muse

Pre-format the cells as text (Format>Cells...>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
[email protected]HIS

"muse calliope" <muse [email protected]> wrote in message
news:[email protected]...
> in the phone number cell and I cant cause by default when I press enter
> zero
> is omitted