Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I wrote:
Dave Peterson wrote: You can actually see more that 1024 characters by adding alt-enters every 80-100 characters. I tried that and I still get ############################ as soon as I exceed the 1,024 characters/cell display limit. What could I have done wrong? Are there any special options to be set for this to work? BTW, I use Excel 2002 (XP). Problem is solved now. What I did wrong was that I still had formatted the cell as "Text" (under "Category"). When I changed that cell format to "General", your method worked. So, thanks for the tip. Peter |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Which the maximum of characters of value in a cell? | Excel Discussion (Misc queries) | |||
Number of characters in a cell (one row, merged columns) | Excel Discussion (Misc queries) | |||
fill or truncate to a certain number of characters in a cell | Excel Worksheet Functions | |||
How do you count number of characters in a single cell | Excel Worksheet Functions | |||
How do you count number of characters in a single cell | Excel Worksheet Functions |