Fractions in Microsoft Excel

  [DELETED] 20:42 04 Oct 2003

I am doing a database of my stamp collection in Excel(I can't get my head round Access) and I am having a bit of difficulty putting in fractions like 2 1/2p.
I can put it in by clicking on insert then symbol then clicking on the half symbol and then insert. Thats where the problem lies. In my stamp collection there are hundreds of stamps with the half symbol and it gets a bit laborious going into insert a symbol each time. In Word I use shortcut keys but Excel dould not seem to have any. Has anyone got any solutions?

  [DELETED] 21:07 04 Oct 2003

Yes, one that will save a little time, little ernie. In the cell enter 2 then hold down the Alt key on your keyboard and type 0189, that will give you 2½ in the cell.

  powerless 21:12 04 Oct 2003


  [DELETED] 21:13 04 Oct 2003

A clever little solution if I say so myself. I was waiting for VoG to come along and beat everyone to it.

Probably won't affect little ernie in this case... but it is, of course, not actually a number that's created - it's a text item. This means you can't do any arithmetic operations on it.

Just a thought if anyone else thinks, 'Ahh, I can use that!'


  [DELETED] 21:16 04 Oct 2003

Or if you type ½ into word then copy it to the clipboard, you could then use Ctrl + V to paste it into the cell.

  powerless 21:17 04 Oct 2003

Is there a hotkey in excel?

  [DELETED] 21:20 04 Oct 2003

That is true, it wont work for calculations, but as little ernie (I don't think) will be using them in calculations........ but you know that already, Chris. It'll be good to see what "the Master" will come up with, though. :-))

  [DELETED] 21:28 04 Oct 2003

Yeah. Where is he?

Slacker :0))

  [DELETED] 21:33 04 Oct 2003

Thanks everyone, that will save me a lot of time.

  Alan2 22:42 04 Oct 2003

Try this:

Put some numbers like 2.5, 1.5 in a couple of cells; select them then click format/cells;

scroll down the category window to Fraction;

click that then in right hand window choose whatever is appropriate say the top one "up to one digit (1/4)" click that then click OK.

Numbers in cells should now read what you want.


  david.h 22:46 04 Oct 2003

have you tried just using tables in word, it may be easier. that is what I did to catalogue a an old collection I have

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

Elsewhere on IDG sites

Microsoft Surface Book 2 15in review

Iglooghost's hyper new music video gives a mutant take on Monument Valley

When is the best time to buy an iPhone?

Quel antivirus gratuit choisir pour un PC ?