HDTutorial
EN
How to Add Plus Sign (+) Before Positive Number in Excel (Easy Custom Formatting Trick)

Playback starts YouTube’s embedded player (privacy-enhanced mode).

How to Add Plus Sign (+) Before Positive Number in Excel (Easy Custom Formatting Trick)

160,714 views June 26, 2020 5:49

Watch on YouTube
ChannelTrumpExcel

Description from the creator

In this video, I will show you how to easily add a plus sign (+) before positive numbers in Excel.

By default, when you add a plus sign before a number, Excel would remove it (as it considers it redundant). But in some cases, you may actually need the plus sign - for example, when you're entering numbers with country code.

This can easily be done using a simple conditional formatting trick.

You can read more about this here: trumpexcel.com/add-plus-sign-before-numbers-exc…

☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - buymeacoffee.com/SumitB

✅ Free Excel Course (Basic to Advanced) - trumpexcel.com/learn-excel/
✅ Free Dashboard Course - bit.ly/free-excel-dashboard-course
✅ Free VBA course - bit.ly/excel-vba-course
✅ Free Power Query Course - bit.ly/power-query-course
✅ Best Excel Books: trumpexcel.com/best-excel-books/

Subscribe to get awesome Excel Tips every week: youtube.com/user/trumpexcel?sub_confirmation=1

#Excel #ExcelTips #ExcelTutorial

About this tutorial

TrumpExcel published this 5:49 video tutorial on June 26, 2020. It has been watched 160,714 times on YouTube.

Channel
TrumpExcel
Category
Education
Duration
5:49
Published
June 26, 2020
Views
160,714
Likes
2,010

Tags

Share

Further reading

  • How To Display a Plus + Sign On ... - How To Excel At Excel howtoexcelatexcel.com

    The negative differences are easy to see. So, how about making the positive numbers just as identifiable with a + sign in front of the numbers. It is really easy in Excel to create these formats using the custom number…

  • How to Add Plus Sign Before Numbers in Excel - Trump Excel trumpexcel.com

    In this tutorial, I will show you a simple way to add a plus sign before a positive number in Excel. So let’s get started! Using a Custom Number Format. You can create a custom number format for the cell where you want…

  • How to add plus sign to multiple positive numbers in Excel? extendoffice.com

    Add plus sign to multiple positive numbers with Format Cells function. To add plus sign before multiple positive numbers, you just need to format cell as following steps: 1. Select the range that you want to add plus si…

This tutorial in other languages