Can Excel be set to automatically add a colon in a cell formatted for time?
by dgh
. Updated 15 years, 6 months ago
Let’s say you enter “1300” and what you would like to have displayed is “13:00”. It would be nice to just enter 1300 and press enter instead of entering 13, pressing the shift key and the colon key and then enter 00 and pressing enter.