255 characters in cells

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

Guest

Is it possible to increase the number of characters allowed in cells to over
255. If not is there another way to allow large entries into cells
 
in excel help, type specifications.
click on workbooks specs. this will tell you all the
limits of your version of excel. (it varies from verison
to version)
in my excel version 2k it says
Column width 255 characters
Length of cell contents (text) 32,767 characters. Only
1,024 display in a cell; all 32,767 display in the formula
bar.
 
What version of excel are you using?

xl95 had the limit of 255 (or 256???) characters per cell.

xl97 increased it to 32k.

But without help, xl will show only about 1000 characters.

If you want to see more, try peppering alt-enters to force new lines within the
cell.
 
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

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Word wrap with > 255 characters 2
How can I copy more than 255 characters in a cell without truncati 1
cell contents truncated 3
cell character limit 8
Tracking Changes Column Limit 2
How do I get more than 255 characters into a cell? 3
Excel 2003, Linked Spreadsheet, Cell Character Count 3

Back
Top