View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sheeloo[_3_] Sheeloo[_3_] is offline
external usenet poster
 
Posts: 1,805
Default Why in some cells text appears as ### and in others as the text it

One reason could be...

In Excel 2003, a cell can hold a maximum of 255 characters...
If you enter more than that then you see #########...


"Dimitris from Athens Greece" wrote:

In some cells, text appears as ###### and in other cells as the text itself.
I want to control, how the text appears. Does anybody knows how can I do it?
Thanks a lot in advance
Dimitris