Hi all,
Cell A1 contains a figure of 100.
Using formula =A1, it shows up 100. This is obvious.
Is there any way (formula) that it can give A1 (cell address) rather than
100 please ? Thanks

Just type A1 instead of =A1


"Elton Law" wrote:

Hi all,
Cell A1 contains a figure of 100.
Using formula =A1, it shows up 100. This is obvious.
Is there any way (formula) that it can give A1 (cell address) rather than
100 please ? Thanks

Hi,
Actually, I have 6550 row data to handle.
Typing all cells will certainly kill me.
So wanna have formula to represent the cell in absolute address.
Anyway, thanks for your response. But this does not help me.


"Teethless mama" wrote:

Just type A1 instead of =A1


"Elton Law" wrote:

Hi all,
Cell A1 contains a figure of 100.
Using formula =A1, it shows up 100. This is obvious.
Is there any way (formula) that it can give A1 (cell address) rather than
100 please ? Thanks

Elton Law wrote:
Hi all,
Cell A1 contains a figure of 100.
Using formula =A1, it shows up 100. This is obvious.
Is there any way (formula) that it can give A1 (cell address) rather than
100 please ? Thanks


Try the ADDRESS() function. Provide more details of what you are trying to
accomplish if you need more help.