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
|