Format as currency within a formula

0

I am trying to sum a column of dollar amounts and label it as "Total: $xx,xxx.xx" in the first row of that column.

I have gotten as far as ="Cost - " & Text(SUM(B2:B), "$0.00")

BUT, it is not correctly formatting the dollar amount. I.e. it reads "$10000.00" instead of "$10,000.00" (missing the comma)

Does anyone know how to fix this?

Thanks!

Michael

Posted 2015-07-27T15:50:12.413

Reputation: 435

Answers

1

I think you can just use the DOLLAR function.

=DOLLAR(1345, 2)

Result: "$1,345.00"

MC10

Posted 2015-07-27T15:50:12.413

Reputation: 7 590

Brilliant - I figured there was a simple answer. Thank you for your help... The site is telling me I have to wait a few more minutes to mark your answer as accepted... – Michael – 2015-07-27T15:55:59.570

No problem, I was originally going to just comment but it wouldn't format as nice. – MC10 – 2015-07-27T15:57:42.640

Asked: 2015-07-27T15:50:12.413

Viewed: 357 times

Active: 2015-07-27T15:53:49.857