We will be migrating from Ask to Discourse on the first week of August, read the details here

How to display numbers as information? [closed]

Hi,

I want to display in a cell two different numbers. I have a value in A1 and A2 and I need these values displayed in A3 as NUMBER (NUMBER)

It would be amazing if the value in parenthesis can be displayed with cents as .00.

Here an example: A1) 2500 A2) (100.50) A3) 2500 (100.50)

edit retag reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp close date 2021-06-22 19:33:33.745219

Sort by » oldest newest most voted

Hi, the solution is: A3=CONCATENATE(TEXT(A1,"0")," (",TEXT(A2,"0.00"),")")

Good luck

Juergen

more

Hi Juergen! I just tried it and it didn't work :/ Sorry, I'm a complete beginner using LibreOffice. Is there something I have to modify in your formula to work in my file or it should work just like it is? Thank you!

( 2020-06-13 21:16:37 +0200 )edit

Sorry now it works. But you must delete "A3" in the Beginning. Formulas start with "=".

( 2020-06-13 21:21:31 +0200 )edit

Unfortunately, didn't work again. I don't know if I'm doing something wrong. I'm using it without the "A3". I come up with this formula and it worked =A10 & "(" & B10 & ")" but there's no space between A10 and B10. i.e 100(50.50)

( 2020-06-14 02:47:34 +0200 )edit

I finally found a way that works. =CONCATENATE(A1;" ";"(";B1; ")") Thank you for all your help!

( 2020-06-14 03:35:50 +0200 )edit

Hi AlexBC,