Simple Format Question

[Ket]

Hello,

I am entering invoice numbers into a spreadsheet, however, Excel is
disregarding any prefix zero's.
Eg 00004756 is shown as 4756.
Other than formatting as text, is there another way to display these
values correctly including the zeros?

TIA


Ket
London

 

[Peo Sjoblom]

For display only you can use a custom format like

00000000