Hello, Please enter date in dd-mm-yyyy only. I have give 25-12-1988 but not accept Configuration: Windows 7 / Chrome 52.0.2743.116

If you want to enter the date like that, not sure what your regional settings are (your location?), but try either... 12/25/1988 or 25/12/1988

Previous Topic Next Topic

Enter date in dd-mm-yyyy

Closed

sam - Aug 24, 2016 at 06:59 AM
fdibbins Posts 33 Registration date Sunday June 19, 2016 Status Contributor Last seen November 20, 2016 - Aug 24, 2016 at 08:38 PM

Hello,
Please enter date in dd-mm-yyyy only.
I have give 25-12-1988 but not accept

Vba userform date format dd/mm/yyyy
Dd-mm-yyyy format in excel - Guide
Vba case like - Guide
Format factory - Download - Other
Number to words in excel without vba - Guide
Samsung format code - Guide

2 responses

Answer 1 / 2

Blocked Profile
Aug 24, 2016 at 04:55 PM

YOu could try:
=text(A1,"DD-MM-YYYY")

See below:

Similar discussions

Change date format dd.mm.yyyy to dd/mm/yyyy

How to change date format from yyyymmdd to mm/dd/yy in Excel?

Change Date Format - dd/mm/yyyy HH:MM:SS to mm/dd/yyyy HH:MM:SS

convert mm/dd/yyyy to mm/yy in excel 2007

Highlight cell if another cell contains any text

Kingston dt 101 prompts me to format it

Similar discussions

Subscribe To Our Newsletter!