fraction into date

  • Thread starter Thread starter pm_sam
  • Start date Start date
P

pm_sam

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.
 
Try formatting the target cell as Text BEFORE copying
OR:
add an single apostrophe before that value: '6/33
Micky
 
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.
Click to expand...

See "display numbers as fractions" in Excel help.

Bill
 
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.
Click to expand...
Display numbers as fractions works, but Excel insists of converting the
answer to lowest common denominator, thus 6/33 becomes 2/11.

Bill
 
Back
Top