Can Excel be set to automatically add a colon in a cell formatted for time? - TechRepublic
Question
January 6, 2011 at 03:18 PM
dgh

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.

This discussion is locked

All Comments