rwmill9716
Active Member
- Joined
- May 20, 2006
- Messages
- 493
- Office Version
- 2013
- Platform
- Windows
I have copied a table from an online service. It's displayed negative numbers using a different symbol (instead of a conventional minus). For example, the -$432 is not treated as a negative number when I try to add it to $1,467.97 in the first column; hence, the #Value! error. How do I change this to a true negative $432? Note, I formatted the last column as currency.