I maintain a membership roster using Excel 2007. The roster includes a column for each member's email address, and I've formatted this column so the content appears in plain text. However, every time I add or update an email address, that cell's formatting automatically inserts a hyperlink with a tiny blue underlined font, forcing me to remove the hyperlink and change the font to the one set for the rest of the worksheet (we don't want hyperlinks in our roster).
I've tried everything I can think to format this column so the format of these cells never changes when I add/update an email address.
There's probably a simple way but I cannot find it. How can I do this?
I've tried everything I can think to format this column so the format of these cells never changes when I add/update an email address.
There's probably a simple way but I cannot find it. How can I do this?