=ADDRESS(1,1,4,1) returns A1
=CELL("address",A1) returns $A$1
Regards,
Stefi

€žElton Law€� ezt Ã*rta:

Hi all,
A1 is a number showing 100.
Using formula =(A1) in cell A2 is equal to 100. This is obvious.
What formula can use so that it can give the cell reference or address of
the cell A1 please ?
That is A1 rather than 100.
Thanks indeed.