I have very large figures in billions in some columns, but I want to format particular cells in other columns that link from them to automatically, round off these values to the nearest thousands. Thank you mates.
Florin thanks so far, but it hasn't worked yet. As an example, if cell A10 has the value 20,000,000,000 and I want cell D10 to reference to that value, I want cell D10 to drop the last three zeros and read 20,000,000.
Florin thanks so far, but it hasn't worked yet. As an example, if cell A10 has the value 20,000,000,000 and I want cell D10 to reference to that value, I want cell D10 to drop the last three zeros and read 20,000,000.