Simple Exel question

bargepole | 23:40 Tue 13th Nov 2007 | Technology

2 Answers

I'm sure the answer to this is staring me in the face, but I rarely use Exel.
Anyway, a simple sum, I'm subtracting the contents of one cell from the contents of another, ie �809.03 minus �33, but I get the answer �776, not �776.03. Any ideas what I need to do to make the pennies (decimal places) appear in the answer?

No address bar etc.please help...

installed xp over vista and now my modem is not recognised?

Answers

1 to 2 of 2

Best Answer

No best answer has yet been selected by bargepole. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.

kempie

You need to change the format of the cell to display the decimals.

Many ways to achieve this - probably easiest to right-click the cell, select Format Cells..., Number, Currency, OK.

bargepole

Question Author

Thanks for that, problem sorted.

1 to 2 of 2

Do you know the answer?