This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
So I am pulling a lot of account balances from excel and summarizing them by different groupings. The only problem is that my input files have negative balances in the for of (###.##) and these parentheses are breaking my sums. Is there a formula to change "(###.##)" to "- ###.##"?
You can take either of the two approaches promoted by @LordNeilLord and @danilang (both are fantastic) and put into a multi-field formula tool. That will let you change the data type to a numeric data type so that you can use it in a sum.'
Or, in the formula tool, you can create a new field based off of the old one, and make it numeric.