Previous Topic Next Topic

How do i change date format in (dd.mm.yyyy)

Solved/Closed
Talha - Oct 4, 2011 at 08:20 PM
 Catherine - Jun 10, 2016 at 12:30 AM
Hello,

How do I change the date format from (dd/mm/yyyy) format to (dd.mm.yyyy) format?

And how can I get today's date in dot format (dd.mm.yyyy). If I use formula -->
=today() , it gives the date format in (dd/mm/yyyy).

Please Help.

Thanks

Related:

2 replies

Answer 1 / 2
annie
Oct 5, 2011 at 12:30 AM
select the date cell, Ctrl + 1 Date, Select the required date format...
1
rohit
Dec 24, 2014 at 09:17 AM
dear sir I want to know how can change date farmat dd-mm-yyyy to dd.mm.yyyy
0
jjsam > rohit
Mar 12, 2015 at 10:13 AM
go to format cells , number tab and select custom then type in dd.mm.yyyy
0
Catherine > rohit
Jun 10, 2016 at 12:30 AM
I would like to know how to change the dd-mm-yyyy . Thank you
0
Gopal
Jul 24, 2015 at 06:57 AM
how can I change date formate in cloum form dd.mm.yy to mm.dd.yy
0

Similar discussions

I forget my safe file password pls help me.
jaspreet singh -
Ambucias -

1 response
Forget file safe password
tasmime -
tasmime -

4 responses
Forgotten file safe and privacy app encryption password in Vivo V5S
anumaha -
ac3mark -

1 response
Vivo file safe password
Princy -
HelpiOS -

1 response
Root directory is full or errors during pasting
5468960 -
aryann9152 -

5 responses
how to format write protected pen drive with file system raw
Nelson Kwame -
Robin -

36 responses