View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.setup
Paul B
 
Posts: n/a
Default How do I change the number of characters per cell?

Lenoch, from excel help,

Cell content 32,767 characters. Only 1,024 display in a cell; all 32,767
display in the formula bar.

but as you have found out,
If you add alt-enters every 80-100 characters, you will be able to see a lot
more than 1024 characters


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Lenoch" wrote in message
...
If pasting longer texts into cells, part of them gets lost. Use the

Alt+Enter
for every cell could be the solution, but really painstaking one. Is there
any way how to cancel this limitation or how to increase the default

number
of characters for all files?