BlueDevil12
New Member
- Joined
- Apr 22, 2021
- Messages
- 1
- Office Version
- 365
- 2019
- Platform
- Windows
- MacOS
- Mobile
- Web
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?