Excel download has the same variable appearing as both numeric and string types in the same column

The Kobo Collect Excel download has the same variable appearing as both numeric and string types in the same column. How do I fix this error? i have coded 1= Urban but my download file has “1” and “urban” appearing in the same download file under one column

Welcome back to the community, @tonderaisengai! Could you kindly share with us a screenshot of your issue so that we could understand it pictorially and help?

it was resolved thank you