[Solved] Combining text and formula
[Solved] Combining text and formula
="$ RESULT: " & (C8+C9) Returns 12 digits to right of decimal point. How do I format it to just 2 digits to right of decimal point?
Last edited by Hagar Delest on Sun May 15, 2022 3:47 pm, edited 2 times in total.
Reason: Tagged [Solved].
Reason: Tagged [Solved].
Open Office 4.1.10; Windows 10
Re: Combining text and formula
Convert the number to a formatted text.
Code: Select all
="$ RESULT: " & TEXT(C8+C9;"0.00")
Last edited by Zizi64 on Sat May 14, 2022 9:52 pm, edited 1 time in total.
Tibor Kovacs, Hungary; LO7.5.8/25.8.5.2 /Win7-10-11 x64Prof.
PortableApps: LO3.3.0-25.8.5.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
PortableApps: LO3.3.0-25.8.5.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.