Remove auto date function in cells

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

Guest

When I type '11/12' for example in Excel 2003 it automatically changes it to
'12-Nov'. How can I remove this function? I tried endlessly to change thing
in 'options' but nothing seemed to work!

Thanks for any help
 
Format the cell for text. (This doesn't fix cells you've already typed
in)
 
It always will do that as it sees a date,
try '11/12 the apostrophe will show in the formula bar but not in the cell,
the ' converts it to text,
Regards,
Alan.
 
Pre-format the cells for TEXT, or type a leading apostrophe in front of your
11/12

Vaya con Dios,
Chuck, CABGx3
 
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

Count cells containing specific text when adjacent cell contains datewithin a range... 4
Data selection from one worksheet into a second worksheet. 1
Format Date in Header 2
Formula to fill cells based on Date of Arrival and Date of Departure 1
excel date problem 3
date auto format 2
Min/Max Dates and Group By 2
Dates show up as a 5 digit number in Excel 2007 3

Back
Top