Displaying insignificant numbers in a cell

[Guest]

Does anyone know how to create a function in Excel that will allow
insignificant zeroes to show before a number? F
or example if I want all of my cells to display four digits (1,324) but one
entry is 897, how can I make the cell view it like 0897? Is this possible?
Thank you so much.

 

[Guest]

Try a custom format of

0000

Mike

 

[Gord Dibben]

Custom format to 0000


Gord Dibben MS Excel MVP

 

[Guest]

Thank you so much!

Try a custom format of

0000

Mike

 

[Guest]

Thank you.

Custom format to 0000


Gord Dibben MS Excel MVP