Previous Topic Next Topic

Enter date in dd-mm-yyyy

Closed
sam - 24 Aug 2016 à 06:59
fdibbins Posts 33 Registration date Sunday 19 June 2016 Status Contributor Last seen 20 November 2016 - 24 Aug 2016 à 20:38
Hello,
Please enter date in dd-mm-yyyy only.
I have give 25-12-1988 but not accept


2 responses

Réponse 1 / 2
Blocked Profile
24 Aug 2016 à 16:55
YOu could try:
=text(A1,"DD-MM-YYYY")

See below:

Similar discussions

Change date format dd.mm.yyyy to dd/mm/yyyy
shatrughna -
Ray -

47 responses
How to change date format from yyyymmdd to mm/dd/yy in Excel?
lmw -
Sf -

12 responses
Change Date Format - dd/mm/yyyy HH:MM:SS to mm/dd/yyyy HH:MM:SS
asmfiaz -
Mazzaropi -

2 responses
convert mm/dd/yyyy to mm/yy in excel 2007
Maria -
rizvisa1 -

1 response
Highlight cell if another cell contains any text
LvH -
LvH -

4 responses
Kingston dt 101 prompts me to format it
mikegr -
R2D2_WD -

5 responses