Why can't I get more than 255 characters in one cell in Excel 07?

B

BigMan68

The Excel specifications state that you can have up to 32,767 characters in a
cell within Excel 2007. When I enter more than 255 characters (which I can
do) and then move down to the next cell, the cell only shows the "#########"
characters. Why can't I still see the text in its proper form? This is
really an unacceptable way to present the information. Thanks for any tips
that you can provide.
 
D

Dave Peterson

Give the cell a General format--or anything but Text.

The problem occurs with strings between 256 and 1024 characters.
 

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

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
How do I get more than 255 characters into a cell? 3
Why is Excel truncating my text to 255 characters? 2
How can I copy more than 255 characters in a cell without truncati 1
How do I copy more than 255 characters per cell? 2
255 characters in a cell 5
Microsoft Excel Cell text limits 3
#### error if cell has more than 255 characters 1

Top