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?
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. :-))