Excel Formula - Nice Currency!

Published on 26 January 2011 at 22:05 by Adam

I hate it in Excel when my currency has to be either spaced out nicely OR red when negative. There is the currency, which has nice colours, for negatives, which is good. But then the accounting format has nice spacing, with the pound sign on the left.

Well, now I can have both!

_-£* #,##0.00;[Red]-£* #,##0.00

Woop!

Example

This post was first published on 26 January 2011 at 22:05. It was filed under archive with tags microsoftexcel.