- Apr 22, 2021
- Office Version
Hello, I’m trying to reformat numbers so they can be used in a SUM formula. My source data has to be copied and pasted into excel. It often contains $ and , which messes up the formula (ex $1,400). It doesn’t change if I update the cell format. Is there a way to quickly get rid of the extra characters so just the number remains?