Issue:
Office 2003, 2007, 2010.
In working w/MS Excel, you discover that your text displaying #### are also actually exporting with #### values.
Solution 1:
Instead of leaving the cell style as "Text" or "No specific format", change to the cell format to "General". You should see the text switch. Export again and confirm column row values are text.
Solution 2:
Use LibreOffice or OpenOffice to open the XLSX file and save as CSV.
previous page
|