Stop Microsoft Excel 2007 from formatting anything?

1

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.

Gabi Diaconescu

Posted 2011-01-31T08:27:50.980

Reputation: 375

Answers

2

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

'12:00

Steve

Posted 2011-01-31T08:27:50.980

Reputation: 2 473

Thanks, but does this work only for date, or for anything, for example currency? – Gabi Diaconescu – 2011-01-31T08:35:23.547

@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 – 2011-11-10T12:54:54.497

Asked: 2011-01-31T08:27:50.980

Viewed: 135 times

Active: 2016-03-27T15:30:47.727