View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Bill Sharpe Bill Sharpe is offline
external usenet poster
 
Posts: 348
Default fraction into date

On 2/2/2010 1:11 PM, pm_sam wrote:
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.


See "display numbers as fractions" in Excel help.

Bill