Date auto fill
 

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

Date auto fill
 

Prefix with ' to enter it as Text
Or preset the cell to Text format.

Steve


On Tue, 31 Oct 2006 20:59:42 -0000, Chris wrote:

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

Date auto fill
 

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?