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