@ Round Formulas
John,
Not sure if this is what you are looking for, but... If you go to Edit Special Formulas you will select only those cells with formulas. (You may want to hit Delete, first, to clear the cells) Type in your formula (make sure it is relative reference where you need relative reference). Than hold the Ctrl key and hit Enter. The formula will fill to all cells in the selection (and adjust the references). Note that this will change all formulas. -- sb "John M" wrote in message ... Hello, I have numerous formulas that I need to convert to @round. Does anyone know of a fast way to do that? I tried an "edit/replace" technique but that did not work since all the formulas are different. Any advice would be much appreciated. John |
All times are GMT +1. The time now is 12:51 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com