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

Ask Your Question
0

How to display numbers as information?

asked 2020-06-13 20:48:48 +0200

AlexBC gravatar image

updated 2020-06-13 20:58:31 +0200

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)

Thanks for your time guys!

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2020-06-13 21:04:48 +0200

dscheikey gravatar image

updated 2020-06-13 21:20:51 +0200

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

Good luck

Juergen

edit flag offensive delete link more

Comments

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!

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

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

dscheikey gravatar imagedscheikey ( 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)

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

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

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

Hi AlexBC,

after your update of the question, cell A2 now reads "(100.50)". This is already a text. So your formula now works perfectly. Before, this was a number and actually the subject of your question. Since you wrote your question in an English forum and used a dot as decimal separator, I assumed that you also use English formula separators. In your comment I saw that you use semicolon instead of comma. That is the reason why my formula did not work for you. Also because there is no number in A2 but a text. If the question is to be regarded as answered, then please click the small white hook in the grey circle. This becomes green with mouseover. Mark the question as answered.

Juergen

dscheikey gravatar imagedscheikey ( 2020-06-14 11:16:32 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2020-06-13 20:48:48 +0200

Seen: 42 times

Last updated: Jun 13 '20