Filter Data table doesn't work properly and cant erase a specific text

[Tammy1998 (Tammy Cruz)]

i don’t know why my output data table look like this. those negative numbers can’t be erased. what shoud i do. i’m still a rookie…

[mz3bel (Mohssine HILAL)]

@Tammy1998

I don’t think it has something to do with UiPath, where do you get your data from ?

[supermanPunch (Arpan)]

@Tammy1998 Can you show us What is your input Data? What type of Filter do you want to Apply?

[Tammy1998 (Tammy Cruz)]

hi sorry for late reply. i have solved it by checking the preserve format on excel application scope. the robot reads the #N/A variable or text as formula thus it returns me a negative numbers.