How do I stop excel replacing numerical values with the date?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have switched off the auto correct function on Excel, but it still replaces
numbers with any given date!! How do I solve this problem?
 
If plain numbers are being displayed as dates, change the format to
General (Cells/Format/Number).

XL's parser will, independently of autocorrect, always interpret a
string like x/y or x-y as a date if it can. To enter such strings
without being parsed, format the cell as Text before entering the
string, or precede the string with an apostrophe, e.g.:

'11-2
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I stop Excel from formating my infromation as a Date? 2
How to stop the auto-format of dates? 5
how do i turn off auto fill? 3
Replace with wildcards 2
Working with sports W-L records without Excel assuming I want dates... 0
Polynomial Regression with Dates 3
Replace numbers with time 3
Rounds the large numeric value 2

Back
Top