GBX to GBP Conversion

henrygregory

I have to confess, I am horrific when it comes to calculations.

Unfortunately, when purchasing stocks, the prices quoted, are often in GBX. Until now, I have been using a useful website to convert for me, but it is getting tiresome having to switch between the site and what I am doing all of the time.

I would like to work out how this value is converted so I can either do it on the calculator (wishful thinking), or create a formula on Excel such that as I enter in GBX prices, it converts them into the GBP in an adjoining cell.

Any help, would be very much appreciated.

bowlhead99

GBX is just great British pennies instead of Great British pounds.

So, Tesco plc shares might be 190p or you might like to say they are £1.90.

Hundred pennies in a pound, so divide the pennies by 100 as your magic excel formula to give you the number of pounds.

Hopefully you will be able to do this with a calculator too.

vectistim

I'm surprised there's a tool for doing this, but try entering 100 GBX into your tool and see how many GBP you get in return.

Can you see a relationship?

mark13

Is it £1 ?

colsten

henrygregory wrote: »

I have to confess, I am horrific when it comes to calculations.

You could try improving, for your own benefit: http://www.nationalnumeracy.org.uk/the-challenge-online/index.html

mgdavid

since when was moving a decimal point 2 places called a calculation?