Format to show "0" at the start of a 15 digit number

[ExcelRoy]

Hi all,

Could i please ask for some assistance

I am looking for a formula to show "0"'s at the beining of a 15 digit number

ie
2315957 need to show as 000000002315957

The number itself will increase over time so not as simple as adding 8x "0" to the formula

Many thanks

 

[Marcílio_Lobão]

ExcelRoy, Good afternoon.

Try to Format the Cell as --> Number --> Custom ---> 000000000000000 ie. Zero 15 times

This is an option for you?

Please, tell us if it worked for you.

I hope it helps.

Greetings from Brazil

 

[ExcelRoy]

Great Thanks Marcilio

 

[Marcílio_Lobão]

ExcelRoy, Good evening.

You're welcome & Thanks for the feedback. Glad to help you.