Insert a fraction Excel 2007

  tonyq 14:45 15 Sep 2010

When I place the following "1/2" (without the quote marks)into a cell using Excel 2007,it changes to the date when I move to another cell.How can I stop it doing this.
Thanks in advance.

  onthelimit 14:48 15 Sep 2010

I would use 'Insert', 'Symbol' then select ½

  wiz-king 15:12 15 Sep 2010

Or put a ' in front of it. This denotes that it is text.

  VoG II 15:26 15 Sep 2010

Or format the cell as Text before entering the value.

  tonyq 17:38 15 Sep 2010

Thank you.

  Noldi 18:12 15 Sep 2010

I use Alt codes for 1/4 and halfs.

Alt 0188 = 1/4
Alt 0189 = 1/2
Alt 0190 = 3/4

This is OK for these fractions but if you require 3/8 then you have to use as above.


This thread is now locked and can not be replied to.

Elsewhere on IDG sites

iMac Pro review

25 book design and illustration tips

iMac Pro review

Idées cadeaux pour geeks et tech addicts