Hi,

I have a suggestion for avoiding this problem in the futu

1. enter the formula in the spreadsheet and with your cursor on that cell
2. turn on the macro recorder
3. press F2, Enter
4. turn the recorder off

If this helps, please click the Yes button

Cheers,
Shane Devenshire

"pol" wrote:

Sorry for reposting this question again.

I am getting an error message ' syntax error' while applying the formula in
a macro. This formula is using to convert the date from a string . But it
will work when I am applying the formula directly in a formula bar

myFormula =
"=IF(LEFT(CELL("format",RC[1]),1)="D",RC[1],DATE(LEFT(RC[1],4),MID(RC[1],5,2),RIGHT(RC[1],2)))"

With thanks and regards

Polachan

Please help