Adding text before a Sum

KatieDi

Hello

I have a basic formula = column, minus column.

These are monetary values so I want the result to be prefixed with a £ but I can't seem to work out how to do it.

I've tried ="£"&SUM(....... but to no avail.

Any suggestions?

Thank you

Katie

David Stokes

You can select the Currency Format from the tool bar and select the format you desire and it should do what you are requesting.

David Stokes

You can select the Currency Format from the tool bar and select the format you desire and it should do what you are requesting.

KatieDi

Well, that was simple! Thank you.