excel numbers

Debbiethepig  wrote:  ``Can anyone help me please``

Hard to say without details.  Ideally, attach the original Excel file, the saved CSV file, and the Excel file after you open(?) the save CSV file.

It sounds like your phone numbers are a string of 21(!!) digits.  I say that because normally, Excel interprets up to only the first 15 digits, replacing any digits to the right with zeros.  And you say that the last 6(!!) digits were replaced with zeros.

In general, numerical strings that are not used as arithmetic numbers should be entered as text.

But regardless, a CSV file is just a text file.  We lose all formatting information when we save as CSV.

So, first, open the CSV file in Notepad and see if the saved data looks exactly like what you expect.

Second, do not open the CSV directly in Excel.  Instead, import the file (click Data > From Text).  The Text Import Wizard has 3 steps.  In the last step, select the column with telephone numbers, and select Text for the Column Data Format.

For any further assistance, again, it would help us help you if you provide the 3 files that I described above.  Click "browse" near the bottom of the reply window.

If the forum does not permit that, upload the files to a file-sharing website, and post the download URLs (*) in a reply here.  I like box.net/files; others like dropbox.com.  You might like onedrive.live.com because it shares the same login as this forum.  But people do not always get the access security right; and I worry that onedrive might change the Excel contents.

(*) If the forum does permit that, spell out the URLs manually.  For example, techcommunity dot microsoft dot com /t5/excel/excel-numbers/td-p/3578873 .