FG

Opening CSV file in Excel corrupts telephone number column

Fresh3 days ago
Mar 15, 202636285 views
Confidence Score0%
0%

Problem

I export listview data to csv file. There is a column, 'Contact No'. This column's data type is 20 field size of text in MS access. Opening this csv with Notepad, it shows the actual data value, 12345678901234567890. But opening it with MS Excel, it shows 12345678901234500000. :O Why are the last 5…

Unverified for your environment

Select your OS to check compatibility.

1 Fix

Canonical Fix
Unverified Fix
New Fix – Awaiting Verification

Fix for: Opening CSV file in Excel corrupts telephone number column

Low Risk

One suggestion is to put an apostrophe in front of the number when you export the data to CSV format. So instead of export .

Awaiting Verification

Be the first to verify this fix

Sign in to verify this fix

Environment