Page 1 of Excel Question (I thought it was easy)

I am trying to set up an excel sheet for the bar here as they always seem to be down on the till , I thought it was easy to add all the denominations using the =sum(b3:b10) but it wont add the pence, 50p, 20p etc....but does add the note totals? not sure how I go about this, duh :(

OK I got it....decimal places....knew it should be easy lol

This item was edited on Thursday, 12th September 2013, 18:37

Well done.

At least you never asked about Excel formula, I went to a course on that once, and gave up, it was horrible, DOH!

It might make it easier to read if you apply a custom format of £0.00p to the cells.. Glad you fingured it out!