Insert a fraction Excel 2007

  tonyq 14:45 15 Sep 10

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 10

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

  wiz-king 15:12 15 Sep 10

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

  VoG II 15:26 15 Sep 10

Or format the cell as Text before entering the value.

  tonyq 17:38 15 Sep 10

Thank you.

  Noldi 18:12 15 Sep 10

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.

Samsung Galaxy S8 review

1995-2015: How technology has changed the world in 20 years

This poetic animation about monsters is illustrated in a Van Gogh painterly style

Apple predictions 2017