View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.misc
Eric_NY Eric_NY is offline
external usenet poster
 
Posts: 58
Default Cell shows with ########

As I indicated in my original message, the cell contains text, not numeric
data.


"Garrym" wrote:

your print width for that column is less than the size of the data. reformat
the data to fit (ie. reduce decimal places) or increase the column width

"Eric_NY" wrote:

In Excel 2007, I've opened a file I created in Excel 2003.

It looked fine in Excel 2003. But now, in Excel 2007, one cell now appears
as #############, onscreen and in Print Preview and when printed. The cell
contents look fine in the the entry line at the top of the screen, or when I
put the cursor in the cell and hit F2 (edit). The cell contains multiple
lines of text. I've tried it both with Wordwrap and without, but the cell
still appears as ################.

Any suggestions on how to get hese cells to display normally again?

Thanks.