Simple Format Question
 

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

For display only you can use a custom format like

00000000



--

Regards,

Peo Sjoblom


"Ket" wrote in message
...
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