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

preview_player
Показать описание
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
Рекомендации по теме
Комментарии
Автор

Thank you immensely for your outstanding comments. 👏👏👏👏🤝🤝🤝

jsiva
Автор

Thank you very much for this solution sir❤

saurabhsingh-ok
Автор

How do I add a colon at the end of a cell in google sheet?

nurizyanaabdrazak