View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Text stored in a cell is displayed as a string of "#####..."

Negative dates/times will also show ##############


Gord

On Mon, 12 Nov 2007 11:48:34 -0800, Gord Dibben <gorddibbATshawDOTca wrote:

Ray

OP stated it was text.

Only numbers need wider column if showing ######

See my other post in same thread.


Gord

On Mon, 12 Nov 2007 09:53:00 -0800, Ray wrote:

expand your column with.