Excel 2008: formulas being replaced?!

[jdu98a]

I'm using Excel 2008 for Mac. I have a document with cells containing about a page worth of html code. The data in those cells is being replaced with a string of "###..." When I click in the cell I can see the html in the formula box, but not in the document itself. This becomes an issue when I try to save the document as as Windows formatted .csv file. All the code in those cells is then actually replaced with "#" My data is lost in the resulting .csv file. I know in an older version of Excel for Mac it did not do this. How can I turn this auto formatting function off?

 

[deathdruid]

Can you expand the column so the data fits? I think if Excel cannot fit data in a column, it displays the "####..." instead. Not sure why the CSV export has that though.

 

[jdu98a]

What is the maximum number of characters allowed in a cell? I have quite a bit of data but I don't think it would be enough to max out a cell.

 

[deathdruid]

255 characters (in a single row, so obviously more if wrapping is on). Just double click on the right column boundary, and it should auto-resize to fit.