absolute
Posted by Stephen Guarnieri on October 03, 2001 8:15 AM
How would you define a cell as absolute? What is the difference between relative and absolute addresses?
Posted by Barrie Davidson on October 03, 2001 8:20 AM
I don't know why you need this because it WON'T be available to Excel, put a couple of double quotes when you are saving it, like this:
"882900201.1590"
Instead of just
882900201.1590
Juan Pablo
Posted by Barrie Davidson on October 03, 2001 8:21 AM
A relative address will change if you copy the formula to another cell, an absolute will not. For example, the formula =A1 is a relative address and if you copy it down one row it will become =A2. The formula =$A$1 is an absolute address; if you copy it down one row it will stay =$A$1. The $ sign indicates an absolute to Excel and can be put in front of the column, the row, or both.
Hope this answers your question.
BarrieBarrie Davidson
Posted by IML on October 03, 2001 9:00 AM
somewhat useless info
If you need to change your references, you can select a cell, highlight the formula in the formula bar and hit F4 to run through the absoluting options. It also works if you highlight individual cell addresses and hit F4 within the formula bar.
Posted by Eric on October 03, 2001 9:14 AM
Cool! (NT)
