"'Mike'" wrote in message
...

"Adrian" wrote in message
...
Hi Mike

On Sun, 29 Jul 2007 09:24:00 +0100, "'Mike'"
wrote:

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?

At a guess (don't have time this morning to 'play' !) -
but right-click the cell and select 'format cells' (on my very elderly
copy of Excel).

There should be an option there that will do what you want - maybe
'text' - you need to convince Excel that it deosn't need to remove the
leading zero...

Hope this helps
Adrian

Mike

BRILLIANT!!!!

Very many thanks to both of you. It works ;-))

I have a load of data which I can now add to and write a book, the data of
which can be transposed into many different tabular ways before going to
the printers :-))

Thanks again

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




I might be a bit late, but here i my two pennyworth.

Format cells (by right click or the menu bar), this gives a multi tabbed
window, one of the tabs is "Number", choose this.

Now scroll down to "Custom", and it the "type" put:

000

or 0000.000, or whatever you need.

Now back to my industrial scale weeding following the rain!

Cheers

John