Enter date in dd-mm-yyyy

[Closed]
Report
-
Posts
33
Registration date
Sunday June 19, 2016
Status
Contributor
Last seen
November 20, 2016
-
Hello,
Please enter date in dd-mm-yyyy only.
I have give 25-12-1988 but not accept


2 replies


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

See below:

Posts
33
Registration date
Sunday June 19, 2016
Status
Contributor
Last seen
November 20, 2016
1
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