View Single Post
  #1   Report Post  
Tony Moffat
 
Posts: n/a
Default Number format-numbers appear as dates in Excel

Numbers that I enter appear as 01-Apr when I really want them to be 4/1
(four to one)..

and..

time entered as 01:06:34 I want to convert to
66.34 seconds....

any help for pensioner, Thanks



Tony