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
- Mouse conversion - Download - Mouse and keyboard
- Dos to unix file conversion - Guide
- Gamescom 2023 dates - Guide
- Defcon 2023 dates - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
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
