Excel 2008: formulas being replaced?!

jdu98a

macrumors newbie
Original poster
Sep 2, 2008
2
0
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

macrumors member
Oct 24, 2006
35
0
Baltimore, MD
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

macrumors newbie
Original poster
Sep 2, 2008
2
0
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

macrumors member
Oct 24, 2006
35
0
Baltimore, MD
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.