home
design & development
Lotus application development
print design
web site development
request a design quote
solutions & consulting
Notes and Domino application development
Lotus Domino administration
Securence Mail Filtering
UNITRENDS backup and recovery
Lotus Notes / Domino Apps
free Lotus Notes apps
hosting
web site hosting
Lotus application hosting
check your mail
request a hosting quote
publishing
media and publishing
sound
client services
help & support
Make Payment
Client Access - Workboard
billing & payment policies
copyright & liability policies
pricing & turnaround policies
privacy statement
contact
e-mail MW
get files
send files
CSV Export of Text Has ###### Symbols instead of Text
Mindwatering Incorporated
Author: Tripp W Black
Created: 04/19/2016 at 11:27 PM
Category:
Notes Developer Tips
General
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
×