Thread: ####### in Cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default ####### in Cell

Format the cell as General (or anything but Text) and reenter the value (F2
followed by Enter should be enough).

Excel has trouble strings between 256 and 1024 characters in cells formatted as
Text.

PSULionRP wrote:

I am typing text in a cell and then I get to a point and it just turns it to
a bunch of # signs...#####################

Why is that happening???

Thanks in advance for your review and hopeful for a reply.

PSULionRP


--

Dave Peterson