I want to enter a date and time as: "10/14/2009@2:28 pm"
How can I do this without having Excel turn it into an email address? I tried pre formating as text, custom formatting, and the only solution I have come up with is to precede the date and time with an inverted comma. I couldn't find anything on the Excel help.
Is there a global 'off' for this function?? Any suggestions would be welcome. Thank you.
How can I do this without having Excel turn it into an email address? I tried pre formating as text, custom formatting, and the only solution I have come up with is to precede the date and time with an inverted comma. I couldn't find anything on the Excel help.
Is there a global 'off' for this function?? Any suggestions would be welcome. Thank you.