SUMIF / Currency Question

[FredJoe699]

Hi,

How do I get column H revenues to show real values? It should be $867,000 not 867 for instance for Alberta

http://www.sendspace.com/file/dxlmay

Thanks in advance,

cro0sh.

[Ace_XL]

In H3 use

Please Login or Register  to view this content.

Copy down

Format as
_-$* #,##0_-;-$* #,##0_-;_-$* "-"??_-;_-@_-

[Kevin UK]

Why don't you upload the file here. Go advanced > Attachments.

[FredJoe699]

In H3 use

Please Login or Register  to view this content.

Copy down

Thank you very much.

Sorry for not uploading here!