View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default excel replacing my text

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

On Sat, 12 Sep 2009 09:28:01 -0700, Dutchess46514
wrote:

I am trying to type in1/60 and excel keeps replacing it with Jan 60 how do I
stop this?