(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
Related:
- (dd/mm/yyyy) format to (dd.mm.yyyy)
- Dd-mm-yyyy format in excel - Guide
- Format factory - Download - Other
- Samsung format code - Guide
- How to format hp laptop - Guide
- How to change whatsapp time format - 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