I need to turn data file into numerical file on excel.?

When I open a file in excel, it saves the numbers as a data file, instead of numerical, so when I try to add everything up, it shows up as an error. Any help?