Hi Connor

Either click the % button on your toolbar, then click on the cell with
the formula,
Or, FormatCellsNumberPercent and select how many decimal places you
want to display.

Regards

Roger Govier



Connor wrote:

Thanks for your note, in your reply you said format cell as a
percentage, I am a complete novice to excel, would you please explain
how you do that.

Cheers