How do I add a colon at the end of a cell in Excel - Excel Tips and Tricks

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

#shorts #short #shortvideo #fyp #excel #microsoft #tiktok #fypシ