(dd/mm/yyyy) format to (dd.mm.yyyy) [Closed]

Report
-
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
-
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


1 reply

Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
790
enter as what is allowed in your excel vesion. then hit "format cells" (under Home ribbon) and click "special" and in the window you type
d.m.y or any other form you like.

experiment

for today()
you can use text function
text(today,"d.m.y")
but under some cases it will be text and not manageable as date(number)

I prefer type
=today()
and format-special as above
3
Thank you

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

CCM 4375 users have said thank you to us this month