Prev: How do i change category names in a drop down list in excel?
Next: Hide Message Bar
From: pm_sam on 2 Feb 2010 20:03
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.
From: Sheeloo on 2 Feb 2010 21:16
Paul,

If you add a 0 before the fraction in EXCEL (0 6/33) then EXCEL won't
convert it into a date... you can try the same trick while copying and
pasting from NOTES...

"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.
From: Bill Sharpe on 3 Feb 2010 16:23
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
From: Bill Sharpe on 3 Feb 2010 16:30
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
From: pm_sam on 4 Feb 2010 12:37
hi Sheeloo...

sorry for the time it has token to respond...

YES I tried that (06/33) and it worked...
also without the zero (6/33) and this works
as well.

is there another way to do it via excel settings
so not the need to bracket these figures in
onenote.

may I thank you for a speedy response and thank
you so much for your help, time and advice.

very much appreciated.

Paul.



 |  Next  |  Last
Pages: 1 2
Prev: How do i change category names in a drop down list in excel?
Next: Hide Message Bar