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

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!

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

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 ###.
--
HTH...

Jim Thomlinson


"rocker22042" wrote:

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!

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

Try making the column wider.

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


On Wed, 31 Mar 2010 10:18:02 -0700, rocker22042
wrote:

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!