how do I get rid of ###### that appear instead of text in excel?
in [General]
|
From: rocker22042 on 31 Mar 2010 13:18 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!
From: Jim Thomlinson on 31 Mar 2010 13:23 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!
From: Chip Pearson on 1 Apr 2010 09:31 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 <rocker22042(a)discussions.microsoft.com> 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!
|
Pages: 1 Prev: VLOOKUP returns 0 (zero) when lookup cell is blank Next: Sorting/Filtering Info |