Using FORMULA.CONVERT() to Change Relative/Absolute References (70096)
The information in this article applies to:
- Microsoft Excel for Windows 95
- Microsoft Excel for Windows 5.0c
- Microsoft Excel for Windows 4.0c
- Microsoft Excel for Windows 3.0a
- Microsoft Excel for Windows NT 5.0
This article was previously published under Q70096 SUMMARY
You can use the FORMULA function with the FORMULA.CONVERT function to
change every reference in a selected area from relative to absolute
reference. You can do this by using the FORMULA.CONVERT function to
calculate the first argument, formula_text, of the FORMULA function.
However, because the FORMULA function will fail if you attempt to use
A1-style references, you need to make sure that the FORMULA.CONVERT
function is returning an R1C1-style formula and not an A1-style
formula.
REFERENCESFunction Reference, version 4.0, pages 168-171
Microsoft Excel Function Reference, version 3.0, pages 89-91
Modification Type: | Minor | Last Reviewed: | 8/15/2005 |
---|
Keywords: | kbhowto KB70096 |
---|
|