How do i change date format in ( [Solved/Closed]

Talha - Oct 4, 2011 at 08:20 PM - Latest reply:  Catherine
- Jun 10, 2016 at 12:30 AM

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

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

Please Help.


See more 

6 replies

Best answer
Thank you
select the date cell, Ctrl + 1 Date, Select the required date format...

Thank you, annie 1

Something to say? Add comment

CCM has helped 1706 users this month

dear sir I want to know how can change date farmat dd-mm-yyyy to
go to format cells , number tab and select custom then type in
Catherine > rohit - Jun 10, 2016 at 12:30 AM
I would like to know how to change the dd-mm-yyyy . Thank you
how can I change date formate in cloum form to mm.dd.yy
noomclub 1 Posts Monday March 23, 2015Registration date March 23, 2015 Last seen - Mar 23, 2015 at 07:29 AM
Thank you
Thanks, I used it to create website