When I enter in my email address, it changes to a name format. I am trying to Index/Match it to another sheet and it doesn't recognize it unless it stays in the email format. How can I set up to not convert?
The email address is changing because the column type is "Contact List". You have two choices:
The Contact List field has some special functionality you may want to keep, if so choose #2 above. If you don't want the new column showing email to show up you can always hide it. A hidden column will still work with filters on reports or queries.
I hope this helps.
Thank you. I was able to use option 2 and it seems to be working.