OT OT Excel ??????
Hi Mike
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?
At a guess (don't have time this morning to 'play' !) -
but right-click the cell and select 'format cells' (on my very elderly
copy of Excel).
There should be an option there that will do what you want - maybe
'text' - you need to convince Excel that it deosn't need to remove the
leading zero...
Hope this helps
Adrian
Mike
|