You need to custom format the col as: hh:mm
then enter the times with a colon, eg: 00:00
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"MikeR-Oz" wrote:
I wish to type in the cells 0100, 0200, 0300 etc but cannot see the format
type that retains these numbers as four digits (allows me to go to 2400) .

Which format is it - I have tried several and it drops the first zero(0) off.

Cheers
Mike