Why is the formatting of email addresses in Excel so problematic? When I
enter an email address into a cell it automatically creates a hyperlink. I
don't want it to do that, I just want it to be text. Furthermore, when it
creates the email address as a hyperlink, it also changes the font. I don't
want it to do that, either. Third, when I manually remove the hyperlink, it
changes the font again. I also don't want it to do that. Fourth, why can't
you highlight an entire column (or row) and remove all hyperlinks from email
addresses.

I think these are serious flaws, and although I'm using Excel on Mac, it
doesn't appear to be an MS punishment for using their software on the Mac for
these same issues exist in Excel for Windows.

What gives?