Software

Ask something
Discussion Locked

Excel Formula

0 helpful
3 replies

by sprocket

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have a user that had a very long column of numbers that need to be displayed in a particular format.

The numbers need to be shown as 6 digits, i.e 000612, 008634 or 082643. Ofcourse with excel the 0's are removed.

What formula could I apply to the column to always display 6 digits, adding either 1,2 or 3 0's depending on the number.

3 replies

by aamontalto

Very simple. Highlight the column you want displayed as a six digit number. Then click on on Format/Cells. Choose the Number tab/custom category. Type in 000000 (that's six zeroes) in the type field. Click on OK and that's it! Any number you type that's less than six digits long will have extra zeroes inserted by Excel to make up six digits.

by sprocket

Thank you. I new it would be simple, but I haven't used Excel for years as I mainly deal with the servers.

The user needed the answer quickly, thats why the points were high.

This discussion is closed to new replies.