Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell shows with ########
Maybe widening the column
"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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell shows with ########
I would have guessed that the problem also appears in xl2003 (you may want to
check again). But try formatting the cell as General (or anything but Text). Excel has trouble strings between 256 and 1024 characters in cells formatted as Text. 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. -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell shows with ########
I assume that this is Text. If the cell is formatted as text and the length
of the text is between 256 and 1024 characters in length then it will display as ###. Longer or shorter is fine. Just a weird little anomoly of text. To get around this reformat the cell as general as it has no such (weird) restriction. -- HTH... Jim Thomlinson "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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell shows with ########
Thanks. I changed the format to General and it works fine.
You're right - that's weird. Is that a bug or a feature...? And if it's a feature, what possible design justification could it have? "Jim Thomlinson" wrote: I assume that this is Text. If the cell is formatted as text and the length of the text is between 256 and 1024 characters in length then it will display as ###. Longer or shorter is fine. Just a weird little anomoly of text. To get around this reformat the cell as general as it has no such (weird) restriction. -- HTH... Jim Thomlinson "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. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell shows with ########
It looks fine after changing to General format.
I believe it was OK in Excel 2003, but I no longer have access to Excel 2003 to see. Thanks. "Dave Peterson" wrote: I would have guessed that the problem also appears in xl2003 (you may want to check again). But try formatting the cell as General (or anything but Text). Excel has trouble strings between 256 and 1024 characters in cells formatted as Text. 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. -- Dave Peterson . |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell shows with ########
Just a weird little bug. Since XL is not a text editor / word processor it
is generally harmless. The only people I know of using XL to write long winded discussions are accountants and they should be taken out behind the wood shed... IMO ;-) -- HTH... Jim Thomlinson "Eric_NY" wrote: Thanks. I changed the format to General and it works fine. You're right - that's weird. Is that a bug or a feature...? And if it's a feature, what possible design justification could it have? "Jim Thomlinson" wrote: I assume that this is Text. If the cell is formatted as text and the length of the text is between 256 and 1024 characters in length then it will display as ###. Longer or shorter is fine. Just a weird little anomoly of text. To get around this reformat the cell as general as it has no such (weird) restriction. -- HTH... Jim Thomlinson "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. |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell shows with ########
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. |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell shows with ########
Same bug/feature existed in earlier versions when char count was 255 to 1024
and Text formatted. Gord Dibben MS Excel MVP On Thu, 17 Dec 2009 13:25:01 -0800, Eric_NY wrote: It looks fine after changing to General format. I believe it was OK in Excel 2003, but I no longer have access to Excel 2003 to see. Thanks. "Dave Peterson" wrote: I would have guessed that the problem also appears in xl2003 (you may want to check again). But try formatting the cell as General (or anything but Text). Excel has trouble strings between 256 and 1024 characters in cells formatted as Text. 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. -- Dave Peterson . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
cant change the cell format it shows too many different cell form | Excel Worksheet Functions | |||
format a cell with a formula so an empty reference cell shows blan | Excel Discussion (Misc queries) | |||
Cell only shows link in text, not contents of reference cell | New Users to Excel | |||
cell shows 20. Formula shows 20. why not 540/27 | Excel Worksheet Functions | |||
Custom format that shows blank cell if another cell is empty | Excel Discussion (Misc queries) |