Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

You entered the date as text ("'" at the beginning and it is probably left-aligned). Right-click on the cell and select "Format Cell", under "Number" you can select then the date format you want.

The date format shown in your example is the standart US format Month/Day/Year shown in formatting window as MM/DD/YYYY.

You entered the date as text ("'" at the beginning and it is probably left-aligned). Right-click Edit the cell (F2) and delete the "'" at the beginning. Then right-click on the cell and select "Format Cell", under "Number" you can select then the date format you want.

The date format shown in your example is the standart US format Month/Day/Year shown in formatting window as MM/DD/YYYY.