Format numbers to keep leading zeros in Excel
- Select the cells on your worksheet where you'll be adding the data.
- Right-click anywhere in the highlighted cells. Then on the shortcut menu, click Format Cells> Number Format>Text >OK.
3. Type or paste the numbers in the formatted cells.
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article