jimcal
Jun 4, 2008, 12:25 PM
I have a date cell formatted - mm/yy "Hours" - When I set the format to wrap text, then reduce the column width (and increase the cell hight to reveal multiple rows of text) I get ### error in the cell. Is there any way to wrap a numeric field?
Thanks in advance,
Jim
JBeaucaire
Jun 4, 2008, 12:52 PM
No, there is no way to wrap text on a numerical field. If space is an issue, you can change the direction of the text, though, so it reads vertically instead of horizontally.
Increase the height of the cell so that it is tall enough for the entire text to be read up/down.
FORMAT > CELLS > ALIGNMENT
90 degrees
Horizontal = center
OK.
How does that look now? Make sure the cell is tall enough.