"Chris Hogg" wrote in message
...
"'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






Robert Harvey has it right. Highlight the column that you wish to
format, then select 'Format Cells' and then 'custom'. Then select the
first in the list and change it in the little window under 'Type:' to
000 or 0000 or whatever, and there you are. Numbers will display with
as many leading zeros as are not otherwise occupied, and you can
perform the usual maths or sort functions on them. No need for
apostrophes or text formatting or whatever. The format you've just
created will also appear as a new format in the custom list for future
use.


--
Chris

I have just tried that Chris and when I move to the next cell the 0 drops
off :-((

Seems the format, cells, text is the best one to use. I just highlight the
complete column before I start and away I go. It will only be one column of
5 or 6 (at the moment) but there will be 1000's of entries of which I would
guess only 2% will lead with a 0, but they HAVE to be sortable with the rest
of the columns when I do change column priority :-)

There will be no mathematical calculations

Many thanks everyone

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