#### being printed instead of characters

  • Thread starter Thread starter mconville
  • Start date Start date
M

mconville

I have a text cell that when it prints the cell prints out as all
######. I have tried to expand to cell but still get only the
characters #. Is there a limit on the number of characters that will
fit into a cell?
 
From the XL2000 Help file, "Worksheet and workbook specifications":

Length of cell contents (text) - 32,767 characters. Only 1,024 display in a
cell; all 32,767 display in the formula bar.



HTH

Ed
 
Try changing the format of the cell to General. Sometimes a cell formatted as
Text will give the ##### even when wide enough.

As far as number of chars in a cell. See Jim's answer this post but note you
can extend that 1024 by sprinkling some ALT + ENTER's throughout.

Gord Dibben Excel MVP
 
Back
Top