ExcelBanter - 6 DIGITS

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - 6 DIGITS (https://www.excelbanter.com/excel-discussion-misc-queries/241687-6-digits.html)

Dave

6 DIGITS

Hi

I have a column with numbers from 1 to 999999. I would like to be able to
show the numbers with 6 digits i.e. 000001, 000002, 001001 to 999999 ETC.

How do I do this?

Thanks

Mike H

6 DIGITS

dave,

Apply a custom format of 000000

Mike

"Dave" wrote:

Hi

I have a column with numbers from 1 to 999999. I would like to be able to
show the numbers with 6 digits i.e. 000001, 000002, 001001 to 999999 ETC.

How do I do this?

Thanks

All times are GMT +1. The time now is 02:28 AM.