View Single Post
  #1   Report Post  
jenniss
 
Posts: n/a
Default how to type a minues figure

i am trying to type a minus figure in excel and it comes up with an error:

the formula you typed contains an error

i confirm in the cell i am typing -1:02 and the cell format is
+[hh]:mm;[red]-[hh]:mm (i want the hours to exceed 24 hour and i want a
minus figure in red)

can anyone help me to type a minus figure?