Microsoft Excel Question:
Download Questions PDF

In MS Access, the long and short date option does not show 4 digit years. How do I achieve the mm/dd/yyyy format?

Answers:

Answer #1
In the date field properties of the table, form, or properties manually input the format you would like. It is not required to choose one of the date formats in the drop down box. Example would be mm/dd/yyyy.

Answer #2
Text function

Download MS Excel Interview Questions And Answers PDF

Previous QuestionNext Question
How do I put password to protect my entire Spreadsheet so data cannot be changed?I wrote the following formula in microsoft excel
=if(and(a1>39, b1>39, c1>39), "passed", "failed" if i enter numbers in the respective cells the formula works but when i entered x in the respective cells there is a problem. excel take x as a number. pls help?