wrote in message
ups.com...
On 29 Jul, 09:24, "'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?

All you need to do is create a custom format. Select the cells, then
format-cells - Number - select Custom - then (for example) type in
000000 as a format.


In this first instance, I have been able to highlight the complete column
then format column as text. I then went down the column changing the O's to
0's :-)) and it worked :-)

The webmaster on our site has done one way, but when I send the next load of
data to go on the site, it will be in the new format :-))

Of course the data for the book will already be in the new format :-)) and
any I add can be new :-)

Thanks everyone for the help.

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