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 22, 2020MVP
Well, I only provide solution to the question the best way I understand it and for me, its not a question of "let so so decide". After all, this is not a competition for me
SergeiBaklan
Jan 22, 2020Diamond Contributor
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?