Concatenate & Text Formula - Parenthetical Text
已回覆I am attempting to add a decimal place into the parenthetical text in the comprehensive financial statement. It appears correct for anything that isn't a zero, where it just leaves the value blank (see column A below). Any suggestions on how to fix it or a new idea on how to pull in the parenthetical numbers into the text.
=CONCATENATE("Change in unrecognized pension and postretirement benefits, net of income taxes of ",TEXT(C7,"####")," - ",TEXT(F14,"$#,###.#;($#,###.#)"),"; ",TEXT(D7,"####")," - ",TEXT(G14,"$#,###.#;($#,###.#)"))
0
-
Use text formatting of "$#,###.0" instead of "$#,###.#" . The # says that if it's 0 not to show it. See below. I think the right column is what you're looking for.
0
評論
2 條評論