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?
Kindly see the link below
https://www.exceljetconsult.com.ng/home/blog/custom-number-formatting-how-to-add-prefix-suffix/
https://www.exceljetconsult.com.ng/home/blog/custom-number-formatting-how-to-add-prefix-suffix/
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- Lets say you have 23.4 in cell A1
1. Select cell A1
2. Press CTRL + 1
3. Select Custom
4. Clear General (below Type)
5. Type in: "Temp = "#,##0.0
6. Then, hold down the AltGr key on your keyboard and type 0176C. (That's the code to have the degree symbol as seen in the attached pictures.
Click OK
Completed. See the two attachmentThat's not enough, you need to define negative part of the custom format string. Desirably zero part as well.
