Hi all,
I have what may be a simple question
Basically I have a cost value: 5.2p (GBP currency: pence), I want to multiply a figure such as 20,000, by 0.052p, to figure out a cost saving
My quesiton is how do I write a formula to say multiply by 0.052 (basically convert the 5.2 p to 0.052? is this possible?)
I have multiple cells to do this for and want to automate it.
Thank you
Bookmarks