Forum Discussion
Solved
suffix in cells with custom format
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...
Of 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?
That's not enough, you need to define negative part of the custom format string. Desirably zero part as well.
You're absolutely correct..
Below is both negative and positive with the prefix and the suffix
1. Select all the number
2. CTRL + 1 and select Custom
3. In the General, executive the logical custom formatting
[>0]"Temp = "#,##0.0oC;[<0]"Temp = "#,##0.0oC
(ALTGR key 0176C to get the degree symbol). See the attached caption.
When the numbers are in negative, you will see: -Temp 5.5oC (for example)
When it is positive: Temp 23.5oC (for example)
Below is both negative and positive with the prefix and the suffix
1. Select all the number
2. CTRL + 1 and select Custom
3. In the General, executive the logical custom formatting
[>0]"Temp = "#,##0.0oC;[<0]"Temp = "#,##0.0oC
(ALTGR key 0176C to get the degree symbol). See the attached caption.
When the numbers are in negative, you will see: -Temp 5.5oC (for example)
When it is positive: Temp 23.5oC (for example)
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
- I actually placed the minus before Temp as the requester put it... I can replace the equal sign with minus sign!
