Lesson#150: how to write all numbers in a minimum of four digits?

Lesson#150: how to write all numbers in a minimum of four digits?

Today I am going to discuss how to write all numbers in a minimum of four digits or three or five. It’s a very common question that people often ask on Excel forums. I shall share two easy methods to make numbers in this type of format.

When you are having a column of numbers like the above pictures apply these methods.

1st method

Select all the cells and right-click then click on Format Cells > Customs. There you put manually 0000 formats to make a default four-digit format. I have shown it in the picture below.

Then click on OK.

2nd Method

Beside another column put a formula like this I have shown below.

how to write all numbers in a minimum of four digits

If your value is on the A1 cell then the formula will be like =TEXT(A1, “0000”)

Then drag the formula and see the result.

how to write all numbers in a minimum of four digits

What happens if we put more than a four-digit number? It doesn’t matter but the number will be shown as at least four-digit.

how to write all numbers in a minimum of four digits

Hope you liked my tips. Subscribe to the channel Excelabcd.

See also  Lesson#236: Excel TEXT Function: Mastering Date and Time Formatting

Hi! I am Puspendu. I am the founder and author of Excelabcd. I am little creative person, blogger and Excel-maniac guy. I hope you enjoy my blog.

Leave a Reply

Your email address will not be published. Required fields are marked *

*