So one might want to use Chip Pearson's
Times, Quick Entry (military time)
http://www.cpearson.com/excel/DateTimeEntry.htm

Or maybe not, I suppose that is the way they are actually to appear
although you could format as hhmm under custom format.

More information on working with dates and times, if you have
dates and times not just four digit numbers.
http://www.cpearson.com/excel/datetime.htm
http://www.mvps.org/dmcritchie/excel/datetime.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm


"Gord Dibben" <gorddibbATshawDOTca wrote ...
But just remember...........it will look like 0753 but is not a not a real time,
only the number 753.