View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Foxwave Foxwave is offline
external usenet poster
 
Posts: 4
Default time in minutes and seconds and .00

Go to 'Format", Cells
click on the number tab on the top
Scroll down to the ' custom' selection and a dropdown box will apear on the
right.
select mm:ss at the bottom of the box


"adam11m" wrote:

I don't know how to format a cell so when I enter a number it is not in a
date format. I want the number to be displayed as minutes, seconds, and 2
decimals.

Thanks in advance
Adam