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

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-...
☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - www.buymeacoffee.com/SumitB
✅ Free Excel Course (Basic to Advanced) - trumpexcel.com/learn-excel/
✅ Free Dashboard Course - bit.ly/free-excel-dashboard-c...
✅ 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: kzread.info...
#Excel #ExcelTips #ExcelTutorial

Пікірлер: 144

  • @PaulEBrownbill
    @PaulEBrownbillАй бұрын

    Really useful number formatting video. Thanks Paul

  • @chubbydawme
    @chubbydawme3 жыл бұрын

    Dude I've never paid attention to hat custom section of formatting. Now I'm using it every time I can.

  • @trumpexcel

    @trumpexcel

    3 жыл бұрын

    Thanks for commenting Michael... Glad you found the video useful!

  • @kerklaan11
    @kerklaan114 жыл бұрын

    No idea that something as simple and useful was possible. I don't think you can ever stop learning new things in Excel. Thank you.

  • @samirsawantvasai
    @samirsawantvasai4 ай бұрын

    Superb. THanks it worked for me.

  • @trumpexcel

    @trumpexcel

    4 ай бұрын

    Glad you found the video helpful 🙂

  • @theenglishproject34
    @theenglishproject343 жыл бұрын

    You never fail in bringing the actual to the public. Thanks brother.

  • @armansaiyed8860
    @armansaiyed88602 жыл бұрын

    you saved much time

  • @shahulhameed-dc2fz
    @shahulhameed-dc2fz3 жыл бұрын

    Excellent.you are master of excel

  • @jimmyderas6857
    @jimmyderas68572 жыл бұрын

    You are the BEST! Thank you

  • @muhammadroslan9226
    @muhammadroslan9226 Жыл бұрын

    Thanks bro! Very helpful👍🏼👍🏼👍🏼

  • @samuelmeende2325
    @samuelmeende23254 жыл бұрын

    Excellent excel tips. I have been thinking about this for long and never figured that out. Thanks so much

  • @aquilafarrell
    @aquilafarrell Жыл бұрын

    This saved my life. Thank you so much.

  • @aashuroy1330
    @aashuroy13304 жыл бұрын

    I am in love with your video and way of teaching. Unlike other you shared all the knowledge regarding that topic with lots of example, specially starting from basic to advance. I have watched your 12hr Complete excel course (26 lesson) . Having a non it background (Mech engineer) you really made it simple. Except Dynamic charting I understood everything 😊. A big round of applause frm my side. Thank you so much for such a amazing videos. One day you will shine . True teacher can win the heart and you proved it. 🙏🙏☺☺

  • @AshokYadav-ym3rr
    @AshokYadav-ym3rr4 жыл бұрын

    Thank you Sumit Sir...I have recommended your channel to many friends!...Great Job!

  • @TheBloodyRosey
    @TheBloodyRosey2 жыл бұрын

    He explained it very clearly. Love it thank you so much.

  • @MRaedAlLulu
    @MRaedAlLulu4 жыл бұрын

    Smart and Useful ! Thank you!

  • @coresnap
    @coresnap Жыл бұрын

    This is amazing! Thanks for the tip. Helps IMMENSELY for my line of work!

  • @akhil_c_mani
    @akhil_c_mani3 жыл бұрын

    Very useful information

  • @twisterrrrr
    @twisterrrrr9 ай бұрын

    You're a legend, greetings from the Netherlands

  • @auto-diciplime237
    @auto-diciplime2372 жыл бұрын

    Thank you very much!

  • @sagarpatil4499
    @sagarpatil44992 жыл бұрын

    Excellent excel tips. Thank you Sumit

  • @wayneedmondson1065
    @wayneedmondson10654 жыл бұрын

    Hi Sumit.. great video! Thanks for all the super tips and tricks using Custom Number Formatting.. very useful :)) Thumbs up!!

  • @fernandocaceres9930
    @fernandocaceres99304 жыл бұрын

    Thnaks Sumit, very useful and simple!!

  • @lambportuza
    @lambportuza3 жыл бұрын

    Very good tutorials. Very well explained. Thank you

  • @Lufc-Chaddy
    @Lufc-Chaddy3 жыл бұрын

    Brilliant- thank you very much

  • @trumpexcel

    @trumpexcel

    3 жыл бұрын

    Glad you found the video useful!

  • @Lufc-Chaddy

    @Lufc-Chaddy

    3 жыл бұрын

    @@trumpexcel looking forward to exploring your channel thanks again from the UK. The internet brings people together teaching and learning as one

  • @arundhatisakharehabitsnmin6221
    @arundhatisakharehabitsnmin6221 Жыл бұрын

    Thank u so much

  • @bhriguketusingh742
    @bhriguketusingh7423 жыл бұрын

    Bro you are a life saver, this exactly what I am looking for

  • @nadermounir8228
    @nadermounir82284 жыл бұрын

    Amazing tutorial. Thank you Sumit

  • @trumpexcel

    @trumpexcel

    4 жыл бұрын

    Thanks Nader... Glad you found it useful!

  • @jasbirkaur3210
    @jasbirkaur32103 жыл бұрын

    I really like the way you explained it, thank you

  • @ProfRoofs
    @ProfRoofs3 жыл бұрын

    *_You are the man! Thanks!_*

  • @ram-it.damn-it
    @ram-it.damn-it3 жыл бұрын

    Highly useful video. Thanks for such videos..

  • @keeloraz9452
    @keeloraz9452 Жыл бұрын

    Super video and explanation. Helped me straight awway.

  • @ashishshelar5328
    @ashishshelar53283 жыл бұрын

    Thank you so much bro......

  • @puneetvij8433
    @puneetvij84334 жыл бұрын

    Sumit Sir, Thanks ! I am your regular viewer. ; )

  • @dinomahmutovic3649
    @dinomahmutovic36494 ай бұрын

    Thank you!

  • @aleksandard.3311
    @aleksandard.33112 жыл бұрын

    thank you very much - so simple, but to figure it out by myself was ...painful. Thank you so much ! :)

  • @nikhilparmar1770
    @nikhilparmar17704 жыл бұрын

    Thanks a lot for great trick as always.

  • @nerochan4094
    @nerochan40942 жыл бұрын

    thank you for this tutorial! you are awesome!!!

  • @nikhilgokhale6508
    @nikhilgokhale65085 ай бұрын

    Thanks, I was struggling with it.

  • @trumpexcel

    @trumpexcel

    5 ай бұрын

    Happy to know the video helped 🙂

  • @nicolenew1708
    @nicolenew1708 Жыл бұрын

    THANK YOU

  • @jemifashion6933
    @jemifashion6933 Жыл бұрын

    Thank you so much

  • @StevenLee-nn6sn
    @StevenLee-nn6sn Жыл бұрын

    that was so smooth and easy. thanks man

  • @shrigopaljhunjhunwala8338
    @shrigopaljhunjhunwala83384 жыл бұрын

    Heartiest Thanks

  • @glndzforonda
    @glndzforonda2 жыл бұрын

    thank you!

  • @deepaknagar5697
    @deepaknagar56974 жыл бұрын

    Awesome video, you always provide interesting contain

  • @ideasoutside6086
    @ideasoutside60862 жыл бұрын

    Nicely explained Thanks 👌👍

  • @lasanalfabetasivxx
    @lasanalfabetasivxx Жыл бұрын

    thanks for the help

  • @Su-ec7pj
    @Su-ec7pj4 жыл бұрын

    Very interesting, Thanks.

  • @amitjinabhai8309
    @amitjinabhai83092 жыл бұрын

    Thank you so very much I really appreciate your help with this!

  • @jenithneranjana8967
    @jenithneranjana89673 жыл бұрын

    Thanks a lot bro... ❤😍

  • @bestof9764
    @bestof97644 жыл бұрын

    AMAZING APPLICATION EXCEL VBA

  • @ethiofunnyviralvideo6696
    @ethiofunnyviralvideo66963 жыл бұрын

    thank you you did it

  • @mosleh67
    @mosleh674 жыл бұрын

    very useful many thanks you are very kind.

  • @ashokkhegde
    @ashokkhegde4 жыл бұрын

    It's a cool tip. Thanks

  • @xxxx-ey7rp
    @xxxx-ey7rp Жыл бұрын

    Bro i was struggling with this fir 12hours you really helped me with some short video😂😂 u almost need to know how to code before using excel

  • @ewlekorblaseyramedmund3234
    @ewlekorblaseyramedmund32344 жыл бұрын

    Thank you Boss,

  • @faisalkt6840
    @faisalkt68403 жыл бұрын

    Excellent information Bro

  • @Ciupremo
    @Ciupremo2 жыл бұрын

    Thank you

  • @SG-mt3pe
    @SG-mt3pe3 жыл бұрын

    Great job, dear

  • @thakuranujsingh4419
    @thakuranujsingh44194 жыл бұрын

    Great, You always give good contain.

  • @trumpexcel

    @trumpexcel

    4 жыл бұрын

    Thank you! Cheers!

  • @966sravanthi
    @966sravanthi Жыл бұрын

    THANK U BRO

  • @swathic1621
    @swathic16213 жыл бұрын

    Super.. well explained 👏

  • @kamlabimla
    @kamlabimla4 жыл бұрын

    Thanks Sumit👍

  • @VictorKB96
    @VictorKB969 ай бұрын

    This is better than Chat GPT

  • @abidejaz1090
    @abidejaz10904 жыл бұрын

    Very informative

  • @ajh22895
    @ajh228952 жыл бұрын

    Thanks, I used that to help with my Excel DnD stat sheet.

  • @amitrawat4546
    @amitrawat45464 жыл бұрын

    Very nice.... you save my day!

  • @trumpexcel

    @trumpexcel

    4 жыл бұрын

    Glad you found the tutorial useful!

  • @pashereef2713
    @pashereef27132 жыл бұрын

    It's a cool Buddy))))))))))))))))) Thank you So much

  • @rakeshsoni7306
    @rakeshsoni73064 жыл бұрын

    Excillent sumit sir👏👏

  • @Deen_WestYorkshire
    @Deen_WestYorkshire3 жыл бұрын

    This bloke is just so good

  • @trumpexcel

    @trumpexcel

    3 жыл бұрын

    Thanks for commenting Deen... Glad you found the video useful!

  • @anupnadkarni9569
    @anupnadkarni95693 жыл бұрын

    Good content. Keep up...

  • @karthigeyannatarajan778
    @karthigeyannatarajan7782 жыл бұрын

    Thanks

  • @laxmiprashant9317
    @laxmiprashant93174 жыл бұрын

    Very helpful

  • @MuhammadUsman-ey1my
    @MuhammadUsman-ey1my2 жыл бұрын

    Super.................

  • @dudukusudhakar2903
    @dudukusudhakar29034 жыл бұрын

    thank you

  • @CLEFFJOE
    @CLEFFJOE Жыл бұрын

    I like your video. 💪

  • @karthikrajgopal8627
    @karthikrajgopal86274 жыл бұрын

    Nice video..

  • @stephanrodriguez6587
    @stephanrodriguez65873 жыл бұрын

    Thanks!

  • @trumpexcel

    @trumpexcel

    3 жыл бұрын

    Glad you found the video useful!

  • @MohAboAbdo
    @MohAboAbdo4 жыл бұрын

    Thanks.

  • @johnkupa8885
    @johnkupa88853 жыл бұрын

    thanks sir

  • @pupununu
    @pupununu2 жыл бұрын

    It works extremely well. Thank you very much. If only I can give you 2 likes.

  • @user-vt8jw8mz4i
    @user-vt8jw8mz4i4 жыл бұрын

    Great

  • @mohammadalbizri2013
    @mohammadalbizri20134 жыл бұрын

    Thanks alot

  • @trumpexcel

    @trumpexcel

    4 жыл бұрын

    Most welcome

  • @justjaionly
    @justjaionly4 жыл бұрын

    nice sumit

  • @peterbrooks1242
    @peterbrooks12424 жыл бұрын

    Brilliant

  • @hazemali382
    @hazemali3824 жыл бұрын

    more than great

  • @Exceltrick4u
    @Exceltrick4u4 жыл бұрын

    Nice

  • @jainpaul770
    @jainpaul770 Жыл бұрын

    informative

  • @NatishHD
    @NatishHD3 жыл бұрын

    Super

  • @timbabitelor
    @timbabitelor4 жыл бұрын

    Thank you Sumit, captivating and informative video as always ! Can I ask a question? I have a series of product numbers like 0158.234555, 0158.891323, 0158.331233, and so on. I want to be able to type just 234555 891323 331233 and use custom format like "0158." but it doesn't work, the "dot" is moved to the end and the "0" at the front disappear. How to get around this?

  • @rahulantiragging
    @rahulantiragging4 жыл бұрын

    Please have a tutorial non dependent drop down or some nice visual way to represent data.

  • @dionilsysoto7595
    @dionilsysoto75954 жыл бұрын

    Cool

  • @nirajkothe482
    @nirajkothe4824 жыл бұрын

    Hi sumit, I am stuck with one logic where i want make auto scheduling for checking tooling i have date of checking and rechecking but concer is that if in month there are 40 tools which i have to check in coming month ..so i need to do manually gantt chart week or date wise ,can you please help me out

  • @somildubey4892
    @somildubey48922 жыл бұрын

    Can we use the country code method in csv file.

  • @moajulius
    @moajulius4 жыл бұрын

    What about costum format, with keeping zero number in back off three decimal point number. Ex 3,780, the zero on the back is usually cant show.

  • @TMQ1981
    @TMQ19812 жыл бұрын

    Thanks, great video, very helpful! But how can I still include the positive sign in the number but also specify that I want it to also be two decimal places? Currently, the format cells format box - as also shown in your video - it seems only allows you to select one specifying formatting clause at a time. so, I cannot have 2 decimal places while also keeping the positive sign as shown the way you have done it. Is there any solutions here? Thanks!

  • @ivanlai5467

    @ivanlai5467

    Жыл бұрын

    You can select the cells and then change the number of decimal places in the home tab

  • @sekhar6106
    @sekhar61064 жыл бұрын

    Sir, Is there anyway we can add type of phone number format to be displayed using Special category - Location -English (India). When selected English (India) the type box is empty.

  • @seymourbutts8739
    @seymourbutts87392 жыл бұрын

    but how do you add a comma separator for larger numbers though?

  • @pa2happiness13
    @pa2happiness133 жыл бұрын

    💞👌🏼

  • @cocoken4995
    @cocoken49952 жыл бұрын

    Hi..there.. tqvm for this nice teaching. I am from Malaysia, .my country code is +60, but i only able to add +6 in front my phone no. instead of +60.... pls help... tqvm, teaccher

  • @esagil_playz4334
    @esagil_playz43342 жыл бұрын

    how expect from + in front if the number in huge for example now in general shows the number 194,500 without the plush in front but when I do with the plush in front it shows +194500. How I make it to show +194,500???