I have an excel table that I am linking, but it keeps showing up as a Text field while the other tables show up as a Number field. How can I change the Text field into a number field.
I tried going to the excel source file and changed the column format to Number but it still wouldn't change to a Number field when I tried to link the data again