Is there any way to extract the result of a formula from a cell to which formatting has been applied.
Ie the cell (A2) from which I want to extract the result of a formula is:
=TEXT(date(year(A1),month(A1)+1,0),"dd-mmm-yy")
And I want to extract the result of the formula (eg 31-May-04).
Is there any way to achieve this?
Cheers
pvr928
Ie the cell (A2) from which I want to extract the result of a formula is:
=TEXT(date(year(A1),month(A1)+1,0),"dd-mmm-yy")
And I want to extract the result of the formula (eg 31-May-04).
Is there any way to achieve this?
Cheers
pvr928