Virtualization, Cloud, Infrastructure and all that stuff in-between
My ramblings on the stuff that holds it all together
Make Excel show phone numbers correctly
Posted by on September 10, 2023
Should you have a requirement to export logs from say a Teams phone system to Excel for some analysis you’ll see that by default it interprets the ‘+’ International dialling symbol and turns the number into a scientific one – which isn’t very handy.
At least on my Mac none of the ‘canned’ formats Excel offers seem to be able to decode the numbers (Not checked in Windows Excel recently), to work around this I set the format to ‘custom’ with the following value to make it show correctly.
"+"##########
This results in
…Which, is the number for Buckingham Palace should you have any business with the king 🙂
Virtualization, Cloud, Infrastructure and all that stuff in-between 