Jan 21 2020 02:00 AM
Good morning I ask you for help, I need to add a suffix to a value read in the cell and I'm using the custom format by adding the following wording "text" 0.0 but when the value stored in the cell is negative the result is this: -text 1.8. is there any way to solve the problem that the minus sign is placed before the suffix?
Jan 21 2020 02:05 AM
Jan 21 2020 02:47 AM
thanks but my problem is that I have to put both a prefix and a suffix, when I read an example value 27.5 I have to view it like this: Temp = 27.5 ° C where the prefix is "Temp =" and the suffix is "° C".
however, when the value read is negative it is displayed as: - Temp = 27.5 ° C
Jan 21 2020 05:51 AM
Jan 21 2020 06:53 AM
Jan 21 2020 07:01 AM
That's not enough, you need to define negative part of the custom format string. Desirably zero part as well.
Jan 21 2020 07:40 AM
Jan 21 2020 08:06 AM
Jan 21 2020 08:12 AM
Jan 21 2020 01:38 PM
@Abiola1 , I understood the question by opposite way, but let @GMettew20 decides.
Jan 22 2020 09:48 AM
it is correct I needed this result: Tevap = -27.5 °C
I have studied your answer and i reproduce it correctly:
"Tevap ="_?-* #.##0,00 "°C";"Tevap ="?-* #.##0,00 "°C";
the only problem is the alignmet, the result si infact : Tevap= - 27,5°C and it epends froma the dimension of column, but it is not very important.
Thankyou for your answer
Jan 22 2020 10:36 AM
Jan 22 2020 12:47 PM
SolutionOf course. That's not about the Excel, that's about English: how to interpret
...when the value stored in the cell is negative the result is this: -text 1.8. is there any way to solve the problem that the minus sign is placed before the suffix?
Jan 24 2020 06:24 AM
I'm sorry but, since I don't speak English well, I probably explained myself wrong. However, your advice has helped me. Thanks anyway
Jan 22 2020 12:47 PM
SolutionOf course. That's not about the Excel, that's about English: how to interpret
...when the value stored in the cell is negative the result is this: -text 1.8. is there any way to solve the problem that the minus sign is placed before the suffix?