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.

"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

Massive book :-((

Mike

Make sure you take regular backups of your files to CD, memory stick or
other media and preferably ask someone else (a family member) to keep the
copies at their house.
The lost count of the number of times over the years I've heard the sad tale
of people writing a book or PhD thesis on a computer only for the hard drive
to fail or computer get nicked - and no backup copies!

The reason for keeping backups "off-site" is in case of a fire. People
commonly keep backup disks in a draw next to their computer which of course
become useless too. If you are concerned about third parties looking at your
backups then simply password protect them, or use WinZip with encryption and
a password.

A question I'm commonly asked is "How often should I do a backup of my
work" - I always give the same reply "How much work are you prepared to lose
and have to re-do?"

David.

"David (Normandy)" wrote in message
...
Massive book :-((

Mike

Make sure you take regular backups of your files to CD, memory stick or
other media and preferably ask someone else (a family member) to keep the
copies at their house.
The lost count of the number of times over the years I've heard the sad
tale of people writing a book or PhD thesis on a computer only for the
hard drive to fail or computer get nicked - and no backup copies!

The reason for keeping backups "off-site" is in case of a fire. People
commonly keep backup disks in a draw next to their computer which of
course become useless too. If you are concerned about third parties
looking at your backups then simply password protect them, or use WinZip
with encryption and a password.

A question I'm commonly asked is "How often should I do a backup of my
work" - I always give the same reply "How much work are you prepared to
lose and have to re-do?"

David.



Thank you David. I do do that, not often enough I must say, but I did do a
massive back up a few days ago.

The majority I have on computer is data and a few 'epistles'.

Most of the work I do is passing information on to others. I am a sort of
'base' and that is why I have been asked to give lectures and give talks of
'Special Interest'.

A lap top linked to the latest type of projector is a god send now. Two
pieces of equipment and no books/lecture notes :-)) THAT is why back up is
so important :-))

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