Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
David Perry
 
Posts: n/a
Default 255 characters in cells

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
  #2   Report Post  
 
Posts: n/a
Default

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.

-----Original Message-----
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
.

  #3   Report Post  
Dave Peterson
 
Posts: n/a
Default

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.



David Perry wrote:

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


--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Add the same character(s) to multiple cells in a column (or row) . flashcatj Excel Discussion (Misc queries) 6 April 22nd 23 06:09 AM
To safety merge cells without data destroyed, and smart unmerge! Kevin Excel Discussion (Misc queries) 0 December 30th 04 07:17 AM
Heps to design Locked/Unlocked cells in protected worksheet Kevin Excel Discussion (Misc queries) 0 December 30th 04 07:09 AM
Convert data of cells to any type: Number, Date&Time, Text Kevin Excel Discussion (Misc queries) 0 December 30th 04 06:55 AM
linking cells in Excel 2003. How to not truncate to 255 characters. GarryFerg Excel Discussion (Misc queries) 5 December 8th 04 03:33 PM


All times are GMT +1. The time now is 07:30 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"