Previous Topic Next Topic

(dd/mm/yyyy) format to (dd.mm.yyyy)

Closed
MADHU - Mar 3, 2015 at 12:46 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - 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


Related:

1 response

Answer 1 / 1
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Mar 7, 2015 at 12:07 AM
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

Similar discussions

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

6 responses
Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses
enter date in dd-mm-yyyy
sam -
fdibbins -

2 responses
How can I publish a study that I have done on this website?
simonrasho -
Daniel_CCM -

1 response
Change Date Format - dd/mm/yyyy HH:MM:SS to mm/dd/yyyy HH:MM:SS
asmfiaz -
Mazzaropi -

2 responses