Enter 20 digits number | Basic Tips & Tricks in excel

Join this channel to get access to perks:
/ @excelaz
Raw data for excel practice download : drive.google.c...
This video shows you how to enter 20 (twenty) digits number using text method in MS Excel 2016.
Excel Tips & Tricks : • Intermediate Excel tip...
Excel Analysis : • Data analysis techniqu...
Excel Functions : • Excel important formul...
Excel DAX formulas : • Dax formula in excel |...
Excel for Job Interview : • Data cleaning in excel...
Excel 365 Features : • Excel new features 201...
Excel 2019 Features : • Playlist
Mobile Excel Tutorial : • Mobile Excel Tutorial ...
Creative & Advanced charts : • Creative & Advanced Ex...
Excel Automation : • VBA & Macro training i...
450 Excel functions with examples : • Learn 450 EXCEL FORMUL...
50+ Important excel functions with examples : • 50+ excel IMPORTANT FO...
Top 60 widely using most popular excel functions : • Top 60 MOST POPULAR ex...
Different types of MIS reports & dashboard creation : • MIS reports & Dashboar...
HR MIS dashboard using Power Pivot : • Headcount report in ex...
#excel
#learnexcel
#exceltutorial
#microsoftexcel
#microsoftexceltutorial
#msexcel
#excelhelp
#ExcelSpreadsheets
#SpreadsheetHelp
#Spreadsheet
#excelexperts
#ExcelSpecialists
#excelsupport
#exceltips
#exceltricks
Thank you for watching this video !!

[@srikantanayakfitness404]

Thank u sir u solve my big problem

[@ExcelAZ]

Glad to hear !

[@Smart_Boy_Siddu]

Thank you sir because this trik is most usefull of me

[@ExcelAZ]

Glad to hear. Cheers 👍

[@theworldof_Atif]

Thank you sir 😭😭

[@ExcelAZ]

You're welcome 👍

[@Sokoeun2808]

Thanks you guy!

[@ExcelAZ]

Welcome dude

[@sarojmanna9469]

thanks so much

[@ExcelAZ]

You're welcome 💝

[@vijaykait8538]

Thank you sir

[@ExcelAZ]

Welcome! Stay home, save lives!

[@raghunathpokla3177]

thanks

[@ExcelAZ]

👍

[@ashokroychoudhury5910]

I HAVE ALREADY 20 DIGIT NUMBER IN SOFTWER WHEN I AM CONVERTING TO EXCEL THEN AFTER 15 DIGIT NUMBER WILL BE 0

[@ExcelAZ]

There are lot of ways to convert. You may try text method or power query method.

[@user-rl4rl6]

20digit Number

[@devthakurclicks]

How to adj data with any changes

[@kaviyarasukumar8655]

One help bro mobile excel aadhar no fix please solution

[@ExcelAZ]

Please brief your query

[@kaviyarasukumar8655]

@@ExcelAZ bro Mobile la Aadhar number fix panurathu epadi

[@czianashtontuliao2393]

Sir i need your help

[@ExcelAZ]

May I know your query?

[@mithunghoshal2170]

Sir Mera kl interview Hai Big Bazaar mein iske liye kuch idea Lena tah aapse can u help me sir?

[@ExcelAZ]

Will do my best. You may send me mail regarding the same.

[@mithunghoshal2170]

Excel (A-Z) sir mujhe mis related job Lena tah starting and I m pursuing CMA intermediate mujhe salary expectation kitni honi chaiyeh is relates se confusion mein hu Kya aap mere resume dhekna chayenge r AAP mujhe suggest krenge ki Kya salary expectation mein rku,mujhe samaj nahi aa raha Hai sir first time Hai isiliye?

[@ponlorkpech4963]

20 digit write in English

[@zulfkarahmedkhan]

When we enter always ####### show

[@ExcelAZ]

Adjust the column for 20 numbers

[@Jojosmith342]

this formula does not work for me. i enetered 20 digits 1 but it convert some last digits 1 to 0

[@ExcelAZ]

How did u do?

[@Jojosmith342]

I did exactly what you did Len(select cell that has numbers >15). then change the setting of the cell to text. It still shows the E+. Thanks for your quick reply@@ExcelAZ. Oh I just found out your number is only 15 excel does not convert to 0 until after 15.. thumbs up.

[@ExcelAZ]

That's great 👍

[@devthakurclicks]

Hlo bro i nead your help

[@ExcelAZ]

Mail me ([e-mail])

[@universalp.k.5957]

are mere bhai bol to sari

[@ExcelAZ]

Thanks for your suggestion bro

[@user-rl4rl6]

28587477667888899775 is a 20 digit number

[@ExcelAZ]

😳