Prefix zero zero in number

Copper Contributor

How is it possible to prefix two zeros in a number. Is it possible to keep 00971 without changing to text.

Is there any way to do it in excel > file> Options?

3 Replies

@pillaisg78 

Use the userdefined number format: 00000

Any way to do it from Options menu...?
Go to the feedback portal.
Ask for it.
Wait for it to be implemented.