Search
« Evernote, iPads and Hell | Main | Power Mailing to Evernote »
Friday
Apr022010

Excel Text Limit

Did you know that sometimes it's better to format text in Microsoft Excel 2007 as something other than text?  If you have cells containing more than 255 characters, cells formatted as "Text" are displayed as a series of # characters.  It makes no difference if you set the cell to word wrap, it simply doesn't display.

The solution is simply to leave the cell format as "General".

PrintView Printer Friendly Version

EmailEmail Article to Friend

Reader Comments

There are no comments for this journal entry. To create a new comment, use the form below.

PostPost a New Comment

Enter your information below to add a new comment.
Author Email (optional):
Author URL (optional):
Post:
 
Some HTML allowed: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <code> <em> <i> <strike> <strong>