Pre-format the cell(s) as text or preface #-## with an apsotrophe which will not
be visible in the cell.


Gord Dibben MS Excel MVP

On Tue, 31 Oct 2006 12:59:42 -0800, "Chris" wrote:

Every time I put in #-## excel changes it to a date. Where do I turn this
feature off?