Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text displays as ####
I am using excel 2007 , have set the cell range to wrap text. Some cells in
the range behave properly, automaticly adjusting row hight and wraping text, while other cells in the range will only display a row of ####### when the text extends past the cell width. If I change the cell range format to "general" they will behave properly but when I change the cell format range back to "text" only the previously affected cells revert to the same problem displaying ####### |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text displays as ####
The Text number format has problem with long text entries. So use General.
The only reason to use Text would be to have entries that would otherwise be treated a numbers to be treated as text. Since your entries are not in danger of that happening there is no reason not to use General. -- Jim "AJH" wrote in message ... I am using excel 2007 , have set the cell range to wrap text. Some cells in the range behave properly, automaticly adjusting row hight and wraping text, while other cells in the range will only display a row of ####### when the text extends past the cell width. If I change the cell range format to "general" they will behave properly but when I change the cell format range back to "text" only the previously affected cells revert to the same problem displaying ####### |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell displays Formula text | Excel Discussion (Misc queries) | |||
picture displays text as webdings | Excel Discussion (Misc queries) | |||
formula displays, not the text | Excel Worksheet Functions | |||
Text displays as ### in a cell. | Excel Worksheet Functions | |||
Formula window displays correct answer while cell displays incorre | Excel Worksheet Functions |