On Sun, 28 Nov 2004 21:05:02 -0800, bob wrote:

So, are you saying that there is no way to format a cell with a value of just
minutes and seconds (4:12)? i tried your formatting suggestions and Excel
placed an hour before the minutes and seconds each time. Even when I entered
the time as 0:4:12, it displayed 12:04:12 AM.

When you state "it displayed 12:04:12 AM" is that in the CELL or in the FORMULA
BAR?

If in the formula bar, there is nothing you can do to change that. (Although
you can hide the formula bar if you are concerned about the end-user).

Formatting only affects how the value is displayed in the CELL. It cannot
change how it is displayed in the formula bar.


--ron