Would anybody advise whether it is possible to amend this formula:
=Concatenate(text(B2,"$##"),text(C2," (##.#%)"))
so that my zero whole numbers are displayed as "0"?
e.g. using the above formula my 0.7% are displayed as .7% (in the cell and in the label), but I want it to be displayed as...