This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anyone know how to reinstate this. I am trying to correct corrupted phone numbers. These are showing as an obscure decimal value including a + sign. I have a feeling I inadvertently selected the option to disable leading zeros originally.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Again: You have to re-enter the phone numbers, manually.
Just changing the format does nothing.
Copy & paste did not work, you can paste but the values only.
If you import the data from an external file, use Power Query.
Andreas.
Text was the default but still got corrupted
Format the cell(s) with the phone numbers as Text, then re-enter the phone number.
The default cell format is General, therefore an input of "0123" is converted into a number and leads to 123.
If a cell is formatted as Text you'll get the input, regardless how many leading zeros you have.
Andreas.