Formatting Date
Closed
Moselley
-
Nov 27, 2020 at 06:06 AM
GeekPeek Posts 115 Registration date Tuesday June 30, 2020 Status Member Last seen June 30, 2021 - Nov 30, 2020 at 04:22 AM
GeekPeek Posts 115 Registration date Tuesday June 30, 2020 Status Member Last seen June 30, 2021 - Nov 30, 2020 at 04:22 AM
My bank has organised my dates as dd/mm/yyyy which is about as useful as a hip pocket in your singlet.
The logical way to organise dates is yyyy/mm/dd
I'm trying Format > Cells > Date > 1999-12-31 > OK to no avail.
What an I doing wrong?
The logical way to organise dates is yyyy/mm/dd
I'm trying Format > Cells > Date > 1999-12-31 > OK to no avail.
What an I doing wrong?
Related:
- Formatting Date
- Excel date format dd.mm.yyyy - Guide
- How to clear formatting in excel - Guide
- Phone formatting software for pc - Download - File management
- Formatting usb mac - Guide
- Whatsapp date format - Guide
1 response
GeekPeek
Posts
115
Registration date
Tuesday June 30, 2020
Status
Member
Last seen
June 30, 2021
41
Nov 30, 2020 at 04:22 AM
Nov 30, 2020 at 04:22 AM
Excel chooses the default regional date format (i.e. MM/DD/YYYY, DD/MM/YYYY, etc.) based on your current location setting. In Excel, you can manually change the format of a particular cell by right-clicking on any cell >> select Format Cells >> Date >> change the Locale (location) to the desired format.
Hope my anser helps you.
Hope my anser helps you.
