OT OT Excel ??????
On 29 Jul, 09:24, "'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?
All you need to do is create a custom format. Select the cells, then
format-cells - Number - select Custom - then (for example) type in
000000 as a format.
|