Do you all encounter such a problem?
Whenever Excel detects that your cell contains a URL or email format, it automatically converts it to hyperlink form. However, in most cases we do not need a hyperlink form.
So how do we avoid Excel turning such cells into hyperlinks?
Example:
Solution:
1. Ctrl + Z to cancel the hyperlink
2. Disable automatic hyperlinks