"'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

To keep the data as numerical, you can make a special format:

1) Select the column

2) Click Format - Cells

3) Choose Custom

4) Put 0### in the field 'Type' (the number of #'s will be the amount of
numbers you want after the 0)

5) Presto :~))

HTH Jenny

"JennyC" 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

To keep the data as numerical, you can make a special format:

1) Select the column

2) Click Format - Cells

3) Choose Custom

4) Put 0### in the field 'Type' (the number of #'s will be the amount of
numbers you want after the 0)

5) Presto :~))

HTH Jenny



Thanks Jenny.

The number of #'s will change, does it matter? Looking at the data so far, I
'think' it will be 01, 02, to 09 then 10, 11, and on, BUT it might go to 099
and possibly even 0999. Other numbers will be conventional without an 0 in
front up to four numbers such as 1009.

The problem is going to lie in sorting these with data in previous and later
columns which will be alphabetical sorts but taking the numbers with them.

Does that make sense???????

For example:

L 099 Jenny
B 321 Mike
A 888 Keith

Sort col one and the letters will reverse to ABL A to the top with 888 Keith
Sort col three and A goes under L 099 and Jenny in line 2

See what I mean? ALL columns must sort.

At a rough guess, 6000 entries in about 8 columns into three different sorts
and printed :-(

As I said somewhere else, I think have bitten off more than I can chew and
this is why the book has never been published ;-))

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

"'Mike'" wrote in message
...


"JennyC" 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

To keep the data as numerical, you can make a special format:

1) Select the column

2) Click Format - Cells

3) Choose Custom

4) Put 0### in the field 'Type' (the number of #'s will be the amount of
numbers you want after the 0)

5) Presto :~))

HTH Jenny



Thanks Jenny.

The number of #'s will change, does it matter? Looking at the data so far,
I 'think' it will be 01, 02, to 09 then 10, 11, and on, BUT it might go to
099 and possibly even 0999. Other numbers will be conventional without an
0 in front up to four numbers such as 1009.

No problem - add as many #'s as you like. It wil only show the actual number
of figures you have
example 0####### wil show 01 up to and includind 09999999

The problem is going to lie in sorting these with data in previous and
later columns which will be alphabetical sorts but taking the numbers with
them.

Does that make sense???????

For example:

L 099 Jenny
B 321 Mike
A 888 Keith

Sort col one and the letters will reverse to ABL A to the top with 888
Keith
Sort col three and A goes under L 099 and Jenny in line 2

See what I mean? ALL columns must sort.

You can sort more columns at one time.
1) Select ALL the columns in the file
2) Click Data - Sort
3) There you will be able to sort one or more columns as required


At a rough guess, 6000 entries in about 8 columns into three different
sorts and printed :-(

As I said somewhere else, I think have bitten off more than I can chew
and this is why the book has never been published ;-))
Mike

Whats the book about then ?
Jenny