DEV Community

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

Posted on

1

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)

Billboard image

The Next Generation Developer Platform

Coherence is the first Platform-as-a-Service you can control. Unlike "black-box" platforms that are opinionated about the infra you can deploy, Coherence is powered by CNC, the open-source IaC framework, which offers limitless customization.

Learn more

👋 Kindness is contagious

Please leave a ❤️ or a friendly comment on this post if you found it helpful!

Okay