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.

Best phone camera 2016/2017: Galaxy S7 vs iPhone 7 vs Google Pixel vs HTC 10 Evo vs OnePlus 3T vs…

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

These are the Best Christmas Ads and Studio Projects of 2016

Super Mario Run preview | Hands-on first impressions of Super Mario Run: Mario's iPhone & iPad…