Forum Discussion
Format issue
When you type something like 2/2 in a cell, Excel for the web thinks you’re typing a date and shows it as 2-Feb. But you can change the date to be shorter or longer.
To see a short date like 2/2/2013, select the cell, and then click Home > Number Format > Short Date. For a longer date like Saturday, February 02, 2013, pick Long Date instead.
Click on the Link to see Tipps.
Additional Informations:
Format numbers as dates or times
You can also press CTRL+1 to open the Format Cells dialog box.
More informations in the Link.
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.
Hi NikolinoDE ,
I am very well aware about the short cut to format via Ctl+1 and date formatting. However, still I am facing the issues even after formatting it as a DATE. I want to filter the date for a particular period which I am unable to do as of now. If you can resolve it, it would be great help.
P.S.: I have found the solution after tricking few things. Thanks for your help anyway.