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.
I am pulling account balances from excel and some are outputting in the form "-##.#E-##". It should output "0", and I want to see if there is a formula to look for this "E-" in the output to write an if to change it to "0". Thanks!
This is an abbreviation of a very small number. If you want it rounded to an integer you can change the data type with a select tool and it will round to the nearest whole number. If you want to round to a number of decimal places, you can use a fixed decimal data type and change the number after the decimal to however many places you would like.