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シ

Пікірлер: 2

  • @yogibearstie
    @yogibearstie24 күн бұрын

    Very useful

  • @RabiGurungXybernetics

    @RabiGurungXybernetics

    22 күн бұрын

    Glad you think so!

Келесі