ExcelBanter - 0 on mobile numbers

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - 0 on mobile numbers (https://www.excelbanter.com/excel-discussion-misc-queries/92792-0-mobile-numbers.html)

shazemmo

0 on mobile numbers

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

Chip Pearson

0 on mobile numbers

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" wrote in message
...
How do I stop mobile numbers losing 1st 0 digit when I press
enter?

All times are GMT +1. The time now is 04:13 PM.