text to numbers

Have you tried selecting the column and setting Data Format to Number?

If that doesn't work then is it possible that your Mac is set to a region that uses , as the decimal separator whereas the downloaded file uses . as the decimal separator (or vice versa).

If so,

1. in the menu go to File > Advanced > Language and Region... and change to a region that uses the decimal separator that is the file (you have to first change the Language in order to be able to change the Region).
2. after switching the Region open/import the downloaded file in Numbers again and make sure the numbers are right-aligned by default indicating that Numbers has recognized them as true numbers
3. at File > Advanced > Language and Region... switch back to your usual region.

SG

umar167 wrote:

Wonderful. It worked with option 2 (switch region) to where the file came from.

However region I had earlier and switched now have the same decimal format "." but in one column is recognised as Text

Yes, you have to first switch the region and then open (import) the file with the data. Then switch back.

SG