Mitel Forums - The Unofficial Source
Mitel Forums => MiVoice Office 250/Mitel 5000 => Topic started by: colcoleman on March 14, 2013, 09:42:27 AM
-
Mitel 5000_5_0 SP2.
We have several hundred numbers in the Speed Dial listing. When I export Speed Dial List to CSV and then pull into Excel, some of the phone numbers import in scientific format (e.g., 1.14962E+12). When I reformat the cells to NUMBER with "0" decimal places, many of the numbers are incorrect.
Is there a way to change the export format?
-
Make the column wider, so all the numbers appear.
-
It doesn't matter how wide i make the column (before changing cell format to NUMBER w/"0" decimal places) - it still shows in scientific format (see attached). And after I change format, many of the numbers are wrong - only the last several digits.
-
Did you try exporting as text file instead of CSV?
-
The only choice in the drop-down when I "export" is CSV - no option for TXT (see attached)
-
I guess the .txt option was added in version 5.1; never noticed before. However, I was able to export a version 5.0 speed dial list to CSV and open it with no problem in Excel.
-
Hi
Have you tried formatting the phone number to text? A "number" does not have leading zeros or multiple decimals, which is why in a database or an excel spread sheet, a phone number can only be stored as a string (text).
Matty Brown
-
This is an Excel issue, and not a CSV or 5000 issue. I would bet if you take the raw CSV file and open it in Notepad, the numbers are correct. Some versions of Excel will take long numbers and put them into scientific notation by default. You might have to highlight that column and change the type of field to something else.
-
This is an excel issue.
Basically you need to import the text, not just open it.
Check this out for a step by step.
http://www.howtogeek.com/howto/microsoft-office/how-to-import-a-csv-file-containing-a-column-with-a-leading-0-into-excel/