Dates in Excel

  • Thread starter Thread starter FJB
  • Start date Start date
F

FJB

Why does Excel assume that when you type December 2004 that you want
the numeric equivalent and not a text entry? Is this just another
illustration of Microsoft knowing what we need before we know it? Thanks
 
I don't know why MS assumes this but you can precede the entry with an
apostrophe and it will be text
 
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

If the average 3
Working with sports W-L records without Excel assuming I want dates... 0
Excel date obstruction! 2
Formula to check two rows for equivalence 3
Excel 2007 filter 3
Excel Vba to change displayed year automatically. 14
count total dates for each month 2
Asset Management - PC Birth Date 11

Back
Top