View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default 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!