Hey EE Community,
I'm looking for a way to get my co-worker's Microsoft Excel 2007 to display the cell value instead of ##### when the value of the formula is longer than the cell width.
Here is the scenario... She is an accountant and has already set up most of her reports in Excel 2003. With the move to 2007, many of the formulas that she has set up display as ##### instead of the contents that she is used to. She doesnt want to expand the column width as this will mess up the page formatting. She also doesnt want to format all the rows as "General" as she will have to do this for all of her spreadsheets. In addition formatting as General displays all negative dollar amounts as -1,255 instead of (1,2555), which she prefers.
So is there a way to give her what she wants in Excel?