ExcelBanter - mobile phones numbers

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - mobile phones numbers (https://www.excelbanter.com/excel-worksheet-functions/15443-mobile-phones-numbers.html)

sparky

mobile phones numbers

When entering mobile phone numbers in excel the leading zero will not display
in the cell.

Gary Brown

Custom format
0-000-000-0000
HTH,
Gary Brown

"sparky" wrote in message
...
When entering mobile phone numbers in excel the leading zero will not
display
in the cell.

Peo Sjoblom

Precede entry with apostrophe

--

Regards,

Peo Sjoblom

"sparky" wrote in message
...
When entering mobile phone numbers in excel the leading zero will not
display
in the cell.

All times are GMT +1. The time now is 06:16 PM.