Custom Number Formats...

Hello

I am currently using a custom cell number format (£#,##0.00) since I would like this currency value to be in brackets, and the following are some examples of the resulting output:

(£25.50)

-(£25.50)

Is there a way please to change this format so that the negative sign appears within the brackets eg:

(£25.50)

(-£25.50)

Thanks for your advice
Robin

Try: (£#,##0.00);(-£#,##0.00);-_);@_)

That works well, many thanks :-)