The number in the cell is formatted as text

[inquisitive-stha]

I am exporting using Fast Excel, however, it is showing this warning The number in the cell is formatted as text ... . I tried by casting the text to intval and floatval but still the same issue. Is there any way to set the column as number, like setColumnFormat in laravel-excel.

[rap2hpoutre]

Hi @inquisitive-stha thank you for your feedback, and sorry for late answer! It has been fixed in version 2.0. Could you try to update to the latest version?

[inquisitive-stha]

Should I use intval and floatval for that one or do we have features like setColumnFormat to set it. Could you link the docs if there is any for this case?

[vodela]

for datetime value its appending the single quote in excell cell, could you please suggest how to fix

[inquisitive-stha]

It should not add a single quote on a date, maybe you are adding it in code.

[vodela]

in the code iam not appending single quote, but the fastexcel package is appending the single quote for YYYY-mm-dd H:i:s formatted date, how to remove it

[MoreiraJ-Prodigentia]

I'm in version 3.0 and this issue still occurs for me on dates.

It should not add a single quote on a date, maybe you are adding it in code.

[rap2hpoutre]

Could you try with 5.3?

[shuraluka]

I'm using version 5.3.0 and the problem from the first sweat continues

[InforPsico]

Hi, I'm having the same problem and I'm using 5.6.
Is it closed without being resolved? If there's a way to format the cell as a number instead of text, please let me know where it's formatted. Otherwise, I'll have to consider using another package since they're requiring the cell to be numeric.