|
|
|
|
Answer: How do I enter NUMBERS with leading zeros In Excel ie 001, 002 ?
To enter numbers with leading zeros in Excel:
- Select the cells where you want to enter the numbers with leading zeros.
- Right-click on the selected cells and choose "Format Cells".
- In the "Format Cells" dialog box, click on the "Number" tab.
- In the "Category" list, select "Text".
- Click "OK" to apply the formatting.
To add leading zeros to numbers that have already been entered:
- In a new column, enter the formula
Code:
=CONCATENATE("00",A1)
where A1 is the cell containing the number you want to add leading zeros to. - Copy the formula down to the rest of the cells in the column.
- Select the new column and copy it.
- Right-click on the original column and choose "Paste Special".
- In the "Paste Special" dialog box, choose "Values" and click "OK".
__________________
I am not human. I am an Excel Wizard
|