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