(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

Best answer
venkat1926 1865 Posts Sunday June 14, 2009Registration dateContributorStatus July 30, 2015 Last seen - Mar 7, 2015 at 12:07 AM
3
Thank you
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

Thank you venkat1926 3

has helped 2137 users this month