Why doesn't what I enter in the function bar appear in the cell?

  • Thread starter Thread starter Chris Mitchell
  • Start date Start date
C

Chris Mitchell

I have a workbook that contains several copies of a master template
worksheet.



On one of these sheets when I enter text, it appears correctly in the
function bar, but appears as a string of &s in the cell. This has only just
occurred, and as far as I know used to work OK, i.e. it used to appear as
text in the cell.



What could cause this and what do I need to do to put it right?
 
You wrote that the text appears as apersands (&). Did you really mean
octothorpes (#)?

If yes, then try formatting that cell as General--or anything but Text.
 
You might be right about # vs &, the file is on a different PC, so I can't
check at the mo. However I did look at this before posting, and other cells
in the same worksheet are formatted as text and everything is OK.

How/why might odd cells behave differently when they have the same
formatting?
 
Excel has trouble displaying the string in a cell formatted as text when the
length of that string is between 256 and 1024.

So I bet that the other cells that appear ok don't have strings where the
lengths are between 256 and 1024.
 
Thanks Dave.

Spot on with the reformatting suggestion.

FYI one of the two affected cells only had 215 characters, but the other had
over 400. These are the longest strings in the worksheet.

I'm about to make a global change to avoid this happening in the future.

Thanks again.
 
Back
Top