General discussion


Excel Formula

By Sprocket ·
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.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

by aamontalto In reply to Excel Formula

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.

Collapse -

by Sprocket In reply to

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.

Collapse -

by Sprocket In reply to Excel Formula

This question was closed by the author

Related Discussions

Related Forums