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

MADHU - Mar 3, 2015 at 12:46 AM - Latest reply: venkat1926 1865 Posts Sunday June 14, 2009Registration dateContributorStatus July 30, 2015 Last seen
- Mar 7, 2015 at 12:07 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


See more 

1 reply

venkat1926 1865 Posts Sunday June 14, 2009Registration dateContributorStatus July 30, 2015 Last seen - Mar 7, 2015 at 12:07 AM
+3
Helpful
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
Was this answer helpful?