Hosted by Dailymotion. For legal issues report at the Copyright Center, report us on DMC, or use the Instant Removal tool.
How to Type 001 in Excel and Keep the ZEROS
48 Views • Sep 29, 2025
Description
What you'll learn:
The quickest fix (Apostrophe/Single Quote)
How to format a whole column as Text
The best method: Custom Number Format (to keep it a number for sorting!)
Keywords & Tags
More from User
Tahir Naqash 1 for 58 vs New Zealand at Dundein 3rd Test 2nd Innings in 1985
Mr. Devotor
Jonty Rhodes 17 off 17 Balls 1 Four vs West Indies 1st ODI, Kingston, April 07, 1992
Mr. Devotor
Sanjay Manjrekar 13 off 24 Balls 1 Four vs Pakistan 4th ODI at Lahore, Dec 22 1989
Mr. Devotor
How to add percentage in pie chart in excel
Mr. Devotor
David Boon 20 off 47 Balls 59 Mins 3 Fours vs West Indies 1st Test, Bridgetown, March 31 - April 02, 1995
Mr. Devotor
Brendon Kurupu 25 off 46 Balls 3 Fours vs Pakistan 1st Match, Sharjah, April 06, 1984, Rothmans Asia Cup
Mr. Devotor
Related Videos
Add Extra Digits in Excel (Leading Zeros, Ending Numbers, Text Format)
Mr. Devotor
Add Leading Zeros - Excel Tips and Tricks
ExcelTips247
custom-formatting-in-excel-custom-formatting-with-leading-zero
poonam yadav
custom-formatting-in-excel-custom-formatting-with-leading-zero
poonam yadav
Formating numbers as text in Excel
InFlames20
Text Formating in Microsoft Excel | The skill Sets
The Skill Sets