LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 58
Default Cell shows with ########

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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
cant change the cell format it shows too many different cell form not able to make changes in sheet Excel Worksheet Functions 0 January 9th 07 04:16 AM
format a cell with a formula so an empty reference cell shows blan M2 Excel Discussion (Misc queries) 3 November 7th 06 10:42 PM
Cell only shows link in text, not contents of reference cell Jay Mac New Users to Excel 4 August 23rd 05 08:36 PM
cell shows 20. Formula shows 20. why not 540/27 griswold Excel Worksheet Functions 2 August 12th 05 05:56 PM
Custom format that shows blank cell if another cell is empty Zdenek Moravec Excel Discussion (Misc queries) 1 March 25th 05 11:45 AM


All times are GMT +1. The time now is 07:49 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"