Save As... results in #######

H

hurdler

I am saving a worksheet as a CSV (Tab delimited would be fine too), bu
there are a few cells that contain greater than 255 characters. I ca
change the column width to 255 maximum, but ### still shows in the cel
display. When I do the Save As... operation, my text file contain
#####s for those cells. I did a quick search to find that this ha
been a problem for a while, but no leads on a solution. Is ther
another option?

version: Excel 200
 
H

hurdler

YES!

changing the long cell to General format cleared up the export/Sav
As... issue
I dont quite get it, but if it works fine.

thanks much
 
D

Dave Peterson

Excel has trouble with cells formatted as Text when the contents have a length
between 255 and 1024.

That doesn't explain why, but I thought I'd add it <vbg>.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Leading Zero dropping off after export to Excel 3
Need to merge worksheets - Excel 2003 0
save as txt saves different tab, why??? 3
Saving double-byte characters as unicode text in a CSV file 4
Excel Save As... text with special characters 2
Numeric values as character in CSV 3
a question about .CSV files 2
XL2010 messing up my templates 2

Top