Text displays as ### in a cell.
Long text in a cell shows up as a long string of ###. When I double click the
cell it displays the text but after pointing to another cell the text disappears and changes to ####. Any idea where the problem is? -- Andre |
Text displays as ### in a cell.
Try formatting the cell as General.
When you use a number format of Text, excel will have trouble with strings between 255 and 1024 characters. Andre wrote: Long text in a cell shows up as a long string of ###. When I double click the cell it displays the text but after pointing to another cell the text disappears and changes to ####. Any idea where the problem is? -- Andre -- Dave Peterson |
All times are GMT +1. The time now is 04:46 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com