M$ Excel masters..

[XA04]

I'm using a simple formular to divide pence by a whole number, so something like: 0.36 divided by 24.
(36p, divided by 24), this answer is 1.5p, but in excel it shows as 0.02.

........... WTF?.

What have I done wrong?, it all works OK in pounds AND pence, just not pence alone

Any help is greatly apreicated, thanks.

Edit: tbh, i'm probably looking at it wrong, confusing the hell out of me now . I'll post once my mind has cleared up, please try help still though..

Ok, in excel.. I think.. it should display 0.015, which should do, then I'll need to use some sort of if statement to make it display 15p.

god, homework sucks, I can't see the dumb arses in my ICT class been able to do this, especially if i'm struggling

[Twigman]

make sure its set to use enough decimal places when displaying number...select relevant cells and click button.
button look something like:

-> .00

also 0.36 is in pound and you want the answer in pence...so change the formula to x100 on the end to convert it

[XA04]

Hi, thanks for the reply.

The other calculations on the page are set out as, 4.50, 1.60 etc.

I know the pence is set out as a pound, that's why I added the 0 and a decimal point after, so 0.36 is 36p.

How do I.. "change the formula to x100 on the end to convert it"?

Thanks

[killie99]

select the cell in question and change it to

=100*(your formula)

To set teh number of decimal places right click the cell "format cell" "number" "currency" and set teh number of decimal places you want

[peterb]

Format the cell to use currency as the number format...

[XA04]

Sorry for the late reply.

killie99, I tried that but it doesn't seem to actually be changing the number from 0.02 to 0.015? (then I think I can use the format cell > number > currency etc bit.

[killie99]

you need to change the number of decimlal places you require: select the cell/cells you want to adjust, right click, "format cell" "number" "currency" and set the number of decimal places you require

[Twigman]

well if you do change it to currency you will only get 2 decimal places, because there are 100p in a pound.

[killie99]

incorrect, you can have more than 2 decimal places when using currency.

[Twigman]

you *can*, but not as default when you select the option.