I have a number of spreadsheets with amounts hard-coded into the cells and denoted in millions.
Example:
Cell A1 = Cash Cell B1 = 1,000,000
Cell A2 = Fixed Assets Cell B2 = 3,500,000
Is there a way to round the numbers to the nearest thousandth (Cell B1 would be 1,000; Cell B2 would be 3,500) for the entire worksheet without undertaking the painstaking process of inserting the ROUND function in every cell? Essentially my problem is that I have hundreds of hard-coded worksheets with numbers and I need to convert the whole lot of them to the nearest thousandth.
Any ideas/thoughts would be most appreciated. Thanks.
Example:
Cell A1 = Cash Cell B1 = 1,000,000
Cell A2 = Fixed Assets Cell B2 = 3,500,000
Is there a way to round the numbers to the nearest thousandth (Cell B1 would be 1,000; Cell B2 would be 3,500) for the entire worksheet without undertaking the painstaking process of inserting the ROUND function in every cell? Essentially my problem is that I have hundreds of hard-coded worksheets with numbers and I need to convert the whole lot of them to the nearest thousandth.
Any ideas/thoughts would be most appreciated. Thanks.