Mike.
Numbers are for purposes of calculation. If you need a leading zero showing
then I suggest your numbers are rather 'text' than numbers. In which case
format the column as "text" you can then have leading zeros and still sort
properly.

David.


"'Mike'" wrote in message
...
I wish to put numbers in a cell which commence with a '0'. For example 067
but when I go to the next cell, the number reverts to just 67.

I can get over it by putting an 'O' (capital o), but this then does not
Data Sort properly.

Can anyone help please?

Mike


--
The Royal Naval Electrical Branch Association.
'THE' Association if you served in the Electrical Branch of the Royal Navy
Reunion Bournemouth August/September 2007
www.rneba.org.uk
"Navy Days" Portsmouth 25th - 27th July 2008. RN Shipmates will have a
Stand