(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
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
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:
- (dd/mm/yyyy) format to (dd.mm.yyyy)
- Dd-mm-yyyy format in excel - Guide
- Kingston format utility - Download - Storage
- Swissknife format - Download - Storage
- Format factory - Download - Other
- Marksheet format in excel - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Mar 7, 2015 at 12:07 AM
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
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
