No. Formatting has no effect on how XL parses the entry (unless you set
the format to Text, in which case you won't get an XL time).

You could use an event macro to divide your entry by 60. Here's one way.
Put this in your worksheet code module (right-click the worksheet tab
and choose View Code):

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
With Target
If .Count 1 Then Exit Sub
If Not Intersect(.Cells, Range("A1:A10")) Is Nothing Then
If IsNumeric(.Value) Then
Application.EnableEvents = False
.Value = .Value / 60
Application.EnableEvents = True
.NumberFormat = "mm:ss"
End If
End If
End With
End Sub




In article ,
edbarunning wrote:

When inputting time that is in minutes and seconds I have to use a decimal
and a zero. i.e. mm:ss.o. Can I reformat so I can input as mm:ss