C Chris Oct 31, 2006 #1 Every time I put in #-## excel changes it to a date. Where do I turn this feature off?
G Gord Dibben Oct 31, 2006 #3 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
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
