Numbers not detecting from excel file.

[amithmurali]

Hi guys,

I have a problem with an excel file.

i have headcount from excel file. i created qvds for it. but when i try to get the sum of the headcount. its not giving me the exact count.

there is some kind of formatting in the excelfile which i cant figure out. please find the app attached.

[amithmurali]

Thanks. it worked

[Kushal_Chawda]

You can also simplify further

KeepChar(trim(HeadCount),'0123456789')