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

Mike

select the range of cells that you want to display numbers in this
format. Use the commands:
format, cells..., Number, Custom

type
000

into the "Type" text box.

This will display as 067, and you will still be able to do calculations
on the number.

If you enter it as "text" by typing single quote 67 ( '67 ) you will
no longer be able to do calculations with it.
Thanks for that Mark.

Calculations will not be required as they are reference numbers relating to
columns 1, 3, 4, 5 and possibly a couple more which MUST all stick together
when sorted into different listings according to different columns. For
example numerical with col 2 as one table, but a complete sort with col 3
which is alphabetical and then again as col 4 which will be alphabetical.

The complete listings in their 'sort', must take all references with them
ready for printing.

Hope that makes sense.

Massive book :-((

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