Previous Topic Next Topic

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

[Solved/Closed]
Report
-
 Catherine -
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

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

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Report

dear sir I want to know how can change date farmat dd-mm-yyyy to dd.mm.yyyy
Report
> rohit
go to format cells , number tab and select custom then type in dd.mm.yyyy
Report
> rohit
I would like to know how to change the dd-mm-yyyy . Thank you
Report

how can I change date formate in cloum form dd.mm.yy to mm.dd.yy
Answer 2 / 2
Posts
1
Registration date
Monday March 23, 2015
Status
Member
Last seen
March 23, 2015
Thanks, I used it to create website
Ask a question

On the same themes