I have a CSV file that I open in Numbers, I need one of the cells to be a URL clickable link though, and in the CSV file if I use something like this, it does not turn into a clickable link in Numbers:
If I type in the above in a cell in the Numbers app, then it automatically turns into a clickable link with the words "Apple".
I am guessing if Numbers opens a CSV file, it does not support functions such as =HYPERLINK. Perhaps it has to be a Numbers formatted file for it to support functions?
Is there a way to "ask" Numbers to open a CSV file in Numbers format so that it can understand the HYPERLINK function?
=HYPERLINK("https://www.apple.com","Apple")as text with Numbers? What happens when you open another text file with only the formula for text such as
=5+2with Numbers again?