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
3

Similar discussions

Unsupported signal. Please check device output
S.Agnew -
Yaya68 -

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

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

1 response
Pc Game show unsupported signal check your output device
Shravanshinde2424 -
dwebb -

1 response