Been trying to figure this out for last couple of hours.
I have this formula
Which creates the excel file fine but creates a #VALUE! in excel.
If I enterthe cell and press RETURN the formula works fine.
I'm using excel5 to render the spreadsheet.