0 on mobile numbers

How do I stop mobile numbers losing 1st 0 digit when I press enter?

Format the cell as Text prior to entering the data, or precede
the data with an apostrophe. The apostrophe will not show in the
cell but will in the formula bar.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"shazemmo" <shazemmo@discussions.microsoft.com> wrote in message
news:EDFCDF80-598A-4F49-9938-69C960C04617@microsoft.com...
> How do I stop mobile numbers losing 1st 0 digit when I press
> enter?