Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

How can I stop Excel 2007 from modifying any character, I don't want to modify the date in any way, I don't want to modify misspells, nothing.

I just want to see the exact text I'm writing.

share|improve this question
up vote 2 down vote accepted

If you prefix your data with a ', it will display as is. That is:


share|improve this answer
Thanks, but does this work only for date, or for anything, for example currency? – Gabi Diaconescu Jan 31 '11 at 8:35
@GabiDiaconescu: I believe so, but I'm not sure as I don't have Excel on this PC. It's only function is to leave entries unformated. I don't see why there should be exceptions to the type of entry this applies to. – Steve Nov 10 '11 at 12:54

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .