View Single Post
  #9   Report Post  
Old 29-07-2007, 11:21 AM posted to uk.rec.gardening
[email protected] robertharvey@my-deja.com is offline
external usenet poster
 
First recorded activity by GardenBanter: Jul 2006
Posts: 139
Default 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.