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!

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!

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!