How to keep leading zeros in Excel #shorts

In this video I will show you a tip to keep leading zeros in Excel useful for when entering phone numbers.

WATCH ME NEXT
✅️ Stop using VLOOKUP in Excel there is an EASIER way...

✅️ How to EASILY convert a Word document into PowerPoint slides

✅️ How to embed an Excel file into Word

🚨 MASTERCLASSES
👉 Master the Basics of Microsoft Excel

👉 Master Projects in Microsoft Teams

🏃‍♂️ DON'T GET LEFT BEHIND

📧 LET'S CONNECT

☕️ FUELLED BY COFFEE

Disclaimer: Some of the links in this description are affiliate links, where I earn a small commission on any of your purchases at no additional cost to you. This helps to support the content I provide on the Ready Steady Excel Channel. Thank you for your support.
#ReadySteadyExcel

[dijonay]

Thanks for the straight forward vid and not making it longer than it needs to be! I could already figure out what to do just from the thumbnail but had to click the vid, just to say thank you :)

[LeahyPhoto]

The apostrophe is the same as formatting as text. Now your numbers will not add up. To get rid of the apostrophe multiply the text by 1 and that explains to the computer that the text is a number.

[cudii]

Saving my life. I hate Excel with a passion

[jshdhsgsh]

is there another way, when I export the data, it causes errors

[helloall]

Big fat subscribe from me. Your my new best friend