Dates conversion
Closed
Herodia
-
Oct 16, 2017 at 10:02 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Oct 16, 2017 at 11:25 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Oct 16, 2017 at 11:25 AM
Related:
- Dates conversion
- Unit conversion excel sheet free download - Download - Spreadsheets
- In excel number to words conversion formula - Guide
- Defcon dates - Guide
- Vivatech 2024 dates - Guide
- Different dates of "end to end encryption message" on blank chat? - Internet & Social Networks Forum
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Oct 16, 2017 at 11:25 AM
Oct 16, 2017 at 11:25 AM
Hi Herodia,
Go to cell properties by right-clicking the date cell (or Ctrl+1). Here you can choose different date formats.
When you want to use a formula for that, then use:
=TEXT(A1,"mm/dd/yyyy")
Best regards,
Trowa
Go to cell properties by right-clicking the date cell (or Ctrl+1). Here you can choose different date formats.
When you want to use a formula for that, then use:
=TEXT(A1,"mm/dd/yyyy")
Best regards,
Trowa
