how do I get rid of ###### that appear instead of text in excel?

R

rocker22042

I used to know how to do this, but I've forgotten...grr...how do I get rid of
those nasty ######### that appear in the fields instead of what I enter...the
correct words appear up in the input header, but the field just shows a
series of pound signs...thanks!
 
J

Jim Thomlinson

Change the format of the cell from text to general. If text is between 256
and 1024 characters in length and the cell is formatted as text you the ###.
 
C

Chip Pearson

Try making the column wider.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional,
Excel, 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Text does not appear in cell, instead "#########..." 5
I type text into a cell and get pound signs instead 6
Windows 10 How to get rid of lines on documents 2
Excel 2000 export loses long text 1
Excel Typed text appears in wrong cell 0
Push Pins Appear in Spreadsheet 4
How do I get rid of line feed characters in wrapped text? 3
How do I get rid of a series of hyperlinks in a column or row 4

Top