View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
steve steve is offline
external usenet poster
 
Posts: 576
Default @ 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