ExcelMedium
New Member
- Joined
- Oct 6, 2018
- Messages
- 4
I have a file which shows monetary values in one column. The majority have a number format (positive values - these are correct). Others have a custom format which shows them as - numbers eg -36.50 (but these numbers are actually positive). How can I easily make the negative ones actually negative. I've tried to look for characters etc using formulae but the - is completed ignored.
