Forum Discussion
GMettew20
Jan 21, 2020Copper Contributor
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...
- Jan 22, 2020
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?
Abiola1
Jan 21, 2020MVP
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/