Thursday, May 5, 2011

Date displayed as number in MS Excel

Query
On entering DATE in Excel, it is displayed as a number rather than Date.

Solution
1) Select "Tools >> Options >> View"
2) Uncheck the option "Formulas"  which appears under the section "Window options".

No comments: