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”.

Author: Stephen Millard
Tags: | excel |

Buy me a coffeeBuy me a coffee

Related posts that you may also like to read