Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Spreadsheets (https://www.askmehelpdesk.com/forumdisplay.php?f=395)
-   -   Wraping Text on a date field (https://www.askmehelpdesk.com/showthread.php?t=223189)

  • Jun 4, 2008, 12:25 PM
    jimcal
    Wraping Text on a date field
    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
  • Jun 4, 2008, 12:52 PM
    JBeaucaire
    1 Attachment(s)
    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.

  • All times are GMT -7. The time now is 09:00 AM.