DEV Community 👩‍💻👨‍💻

Cover image for Excel Formula - Nice Currency!
Adam K Dean
Adam K Dean

Posted on

Excel Formula - Nice Currency!

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

Top comments (0)

⬇️ The only reason people scroll to the bottom...

 

is because they want to read more. Sign up for an account to bookmark, comment, and react to articles that interest you.