| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to show real text insted #
Hi,
I have 2 cell merged. When I have more then 255 caracters Excel show ###. How to force Excel to show thw text? Tank's Patrice |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to show real text insted #
Patrice
Format the cell to General. Excel has a problem with 255-1024 characters if formatted to Text. Also, you cannot place any more text in merged cells than you can place in a single cell. Gord Dibben MS Excel MVP On Wed, 7 Jun 2006 07:42:02 -0700, Patrice wrote: Hi, I have 2 cell merged. When I have more then 255 caracters Excel show ###. How to force Excel to show thw text? Tank's Patrice |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text using Alt+Enter does not show up (row height not a problem) | Excel Discussion (Misc queries) | |||
| Excel will not show all text entered in a Cell merged from 9 rows | Excel Discussion (Misc queries) | |||
| Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
| Text Wrapping | Excel Discussion (Misc queries) | |||
| Wrap and merge text will not show all lines | Excel Discussion (Misc queries) | |||
Linear Mode
