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.