D Dutchess46514 Sep 12, 2009 #1 I am trying to type in1/60 and excel keeps replacing it with Jan 60 how do I stop this?
T T. Valko Sep 12, 2009 #2 Either pre-format the cell as TEXT or precede the entry with an apostrophe like this: '1/60.
J JP Ronse Sep 12, 2009 #3 Hi Dutchess, Try '1/60, if you want the division of 1/60, try "=1/60" (no quotes). Wkr JP
G Gord Dibben Sep 12, 2009 #4 Excel see 1/60 as a date. Preformat the cell as text or preface 1/60 with an apostrophe which won't show in the cell. Gord Dibben MS Excel MVP
Excel see 1/60 as a date. Preformat the cell as text or preface 1/60 with an apostrophe which won't show in the cell. Gord Dibben MS Excel MVP
