J jdj420 Apr 14, 2010 #1 I want to know if there is a way to enter the value of a cell as (for example) 2330 and it display as 23:30?
I want to know if there is a way to enter the value of a cell as (for example) 2330 and it display as 23:30?
J Jim Thomlinson Apr 14, 2010 #2 Check ou tthis link. I have used variations of this very successfully... http://www.cpearson.com/excel/DateTimeEntry.htm
Check ou tthis link. I have used variations of this very successfully... http://www.cpearson.com/excel/DateTimeEntry.htm
