Dates conversion
Closed
Herodia
-
Oct 16, 2017 at 10:02 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Contributor Last seen December 27, 2022 - Oct 16, 2017 at 11:25 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Contributor Last seen December 27, 2022 - Oct 16, 2017 at 11:25 AM
Related:
- Dates conversion
- Apple iphone 13 release dates - Guide
- Different dates of "end to end encryption message" on blank chat? ✓ - WhatsApp Forum
- Using nested if to blank out adjacent cells - Excel Forum
- Mwc barcelona dates - Guide
- Mouse conversion pro apk - Download - Mouse and keyboard
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Contributor
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