View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
Curious Curious is offline
external usenet poster
 
Posts: 36
Default why do some cells automatically switch to ####### when I write

Hi Eduardo,
Thanks for responding.
Tried expanding the column width to the max of 255 but still the same
result. Thing is - if I double click in the column, the text re-appears, and
it stays in the typing bar above, but once I leave the cell or try to save,
the ########## return.

"Eduardo" wrote:

Hi,
That is because of the column width, just expand it and you will be able to
see what you typed

"Curious" wrote:

I am fairly new to Excel and finding that when I finish typing in some cells,
the text disappears and I get a continuous line of ##### when I move out of
that cell. How do I stop this from happening?