Hi fullymooned!

See:
Chip Pearson:
http://www.cpearson.com/excel/DateTimeEntry.htm

There's a tried and tested subroutine there.
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia

Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
"fullymooned " wrote in
message ...
I have a whole column in which I need to be able to enter a number
and
it should convert it to the time format. If I enter 100 it should
convert it to 1:00. Similarly entering 2300 should automatically be
converted to 23:00.

Thank you


---
Message posted from http://www.ExcelForum.com/