View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
pm_sam pm_sam is offline
external usenet poster
 
Posts: 17
Default fraction into date

hi all members... I have excel 2007 and when I enter a number like 6/33 it
turns it into Jun-33. this number 6/33 is being copy from one note 2007 and
pasted into excel. I have tried to manipulate it but to no success and have
checked out 'excel options'. can someone please help. I thank all for your
time and advice and look forward to a reply. many many thanks. Paul.