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.

fraction into date
 

Try formatting the target cell as Text BEFORE copying
OR:
add an single apostrophe before that value: '6/33
Micky


"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.

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

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

Bill