Learn how to add a colon at the end of a cell. Essentially, automatically insert a colon symbol at the end of the cell in Excel. But, if the cell is blank, a colon is not entered.

Here are the steps.
1) Select all fields.
2) Ctrl + 1
3) Number tab
4) Custom
5) @ * //:
6) OK

#microsoft #excel #exceltips #tips #exceltricks #tricksandtips

Please take the opportunity to connect and share this video with your friends and family if you find it useful.