I have a very large XML file of over 650,000 lines, and when I open it in Excel 2007, some cells (multiple line ones) are shown as a series of #s. When I double click on them the content appears, when exported to csv those contents are replaced by #s like this:
######################################################################################################################################################################################################################################################################################
I know it should be a width problem, but how can I fix it? I resized the cell to 255 characters width and a height of 2000 and still couldn't solve it. Please note this is formatted as text. As I am new to XML importing, I thought that might be related. How can I solve this? I tried to save it as a csv but whatever format I use, it exports the series of #s instead of the content.
