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

I'm sure there is a format that allows leading zeroes but I can't
check just now. If you can't find it try the
microsoft.public.excel.misc newsgroup.

Steve

--
Steve Wolstenholme Neural Planner Software Ltd

EasyNN-plus. The easy way to build neural networks.

http://www.easynn.com