If the cell has a formula, it returns it on text format. 

Formulas should start with a "=" sign, and should always use "," as the parameter separator and "." as decimal separator. While localized Excel versions use ";" to separate between parameters, we use the English locale, so your application will work the same no matter the computer regional settings. Also, all function names should be in English, no matter what version of Excel you have installed. 

If in doubt of how a function is names in Rnglish or what the exact syntax should be, you can always write the formula in Excel, open it with FlexCel and read the formula of the cell. 

This will assign a formula to cell A1: 

FlexCelImport.CellFormula[1,1] := '=sum($C$1, D4, 47, COUNT(A1:A2,A6,3))+count(A1:A5, 5)';

TFlexCelImport Properties