Computer and Web Articles

You’re working in your Excel spreadsheet, typing text into a cell. You hit Enter to move on to the next cell and WAIT A SECOND. Your text in the last cell just turned into a long line of hashtags. (###################)

And nothing you do fixes the problem. It’s just hashtag city.

Here’s what you do: Right click the cell (or highlight all the cells in which you’re having the problem then right click on one of them). Choose Format Cells from the menu that popped open. Let me guess. The word Text is highlighted in the list you’re looking at, isn’t it? Let’s change that. Click on General, then click the OK button, and you’re all set. Easy.

Curious as to why that was happening? In Excel, cells that formatted as Text are allowed to contain up to 255 characters. Cells formatted as General are allowed to contain up to 1024 characters.