| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why do not all words show up in an excel cell?
When I am wrapping text in a cell and get a large amount of characters, it
stops displaying them in the workbook, though it is visible in the fx bar. I have heard that there is a max # of characters, but I don't think I am anywhere near the number. Also, I have confirmed that the cells are set to general formatting, but still no luck. Any ideas? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Why do not all words show up in an excel cell?
Jerry
You can enter 32,767 characters in a cell. Unfortunately only about 1024 will show or print. If you add an Alt + Enter every 100 characters you can increase this limit. Gord Dibben MS Excel MVP On Thu, 12 Jul 2007 11:06:01 -0700, Jerry wrote: When I am wrapping text in a cell and get a large amount of characters, it stops displaying them in the workbook, though it is visible in the fx bar. I have heard that there is a max # of characters, but I don't think I am anywhere near the number. Also, I have confirmed that the cells are set to general formatting, but still no luck. Any ideas? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i flip words in a cell (not picture) in excel? | Excel Discussion (Misc queries) | |||
| How to show numbr in words like (100 = One Hundred ) | Excel Discussion (Misc queries) | |||
| Format cell to show numbers in words | Excel Worksheet Functions | |||
| how do i show figures as words? | Excel Discussion (Misc queries) | |||
| Excel formula for seperating two words in the same cell. | New Users to Excel | |||
Linear Mode
