when i entered 002566 or something with 0, 0 disappers. How can i add 0 before a number.
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Adding 0
0
Discussion
Please don't forget to select the answer that worked for you! Just click the Select Answer button at the bottom of the desired answer.
don (rep: 1989) Feb 6, '18 at 10:47 am
Answers
0
There are two ways.
- Enter the number as text.
For this purpose you can eitehr set the cell format as Text or you can precede the number with an apostrophe. Enterint '002566 will show the elading zeroes. The apostrophe will remain invisible but use of the number for calculations will be limited. - Set a custom number format for the cell.
This will only work for you if the number of digits is known. The number format "000000" will cause the cell so formated to display any number with six digits, filling the missing digits with leading zeroes. the number 1 will be displayed as 000001.
To set the number format select Format Cells from the right-click or Format menus, on the Number tab select Custom and enter the desired format in the Type field (without quuotation marks).