View Single Post
  #11   Report Post  
Old 29-07-2007, 01:38 PM posted to uk.rec.gardening
®óñ© © ²°¹°-°³ ®óñ©  ©  ²°¹°-°³ is offline
external usenet poster
 
First recorded activity by GardenBanter: Jan 2007
Posts: 98
Default OT OT Excel ??????

On Sun, 29 Jul 2007 09:24:00 +0100, "'Mike'" wrote
and included this (or some of this):

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?


'067 will show as 067.

It will however be text, not a number.


--
®óñ© © ²°¹°-°³