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

How to set date format dd-mm-yyyy in vivo
Date formula in excel dd/mm/yyyy - Guide
How to change date format in excel - Guide
How to change date format in openoffice - Guide
How to reset safe folder password without losing data in vivo ✓ - Android Forum
Excel date format dd/mm/yyyy ✓ - Office Software Forum

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!