auto correct option

G

Guest

Hello there.

Please say if you know how to switch-off auto correct options from 01/01 -
9-12 to 1st January and 9 December respectively,

Thanks a lot
 
D

Dave Peterson

You can preformat the cell as text and then do your data entry.

You can prefix your entry with an apostrophe: '01/01
 

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

Word 2007 - Typing date in document 1
Please help! date showing as 1900/01/00 2
Sick Leave count 2
count of attendance 1
Count IF multiple criteria 7
Getting MM-DD HH:MM out of Julian date 4
2 dimensional date sort 1
join multiple queries in one query "Attendance calculation" 3

Top