Text Format problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello all,

I have some cells formatted as text and when I put 256 + characters I have
the problem that the cell show "############".

How can I fix it without changing the format of the cells?

TIA
P-A
 
Try putting some line breaks (Alt-Enter) into your text every 200 or so
characters
 
Excel has a problem with cells formatted as text when number of characters is
between 255 and 1024(approx)

Format the cells as General.


Gord Dibben Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Entering a Text Symbol ? 2
Quote Marks Question 2
Numbers change in cell even when formatted as text 4
Text in Text-formatted cells changes to ### after the 255th charac 2
Numbers showing Up Centered in Cell ? 1
How do I prevent a long string of text from wrapping in a text fil 1
CSV->Excel Data Problem 1
Time format 10

Back
Top