Excel 2008: formulas being replaced?!

Discussion in 'Mac Apps and Mac App Store' started by jdu98a, Sep 2, 2008.

  1. jdu98a macrumors newbie

    Joined:
    Sep 2, 2008
    #1
    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?
     
  2. deathdruid macrumors member

    Joined:
    Oct 24, 2006
    Location:
    Baltimore, MD
    #2
    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.
     
  3. jdu98a thread starter macrumors newbie

    Joined:
    Sep 2, 2008
    #3
    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.
     
  4. deathdruid macrumors member

    Joined:
    Oct 24, 2006
    Location:
    Baltimore, MD
    #4
    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.
     

Share This Page