View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jason M[_2_] Jason M[_2_] is offline
external usenet poster
 
Posts: 2
Default Change a specific figure i.e 0:00 and 24:00 to display as "MIDT"

I'm trying to get a cells to show the word "MIDT" when a time figures 0:00
and 24:00 are entered in the cell! Can anyone help me?