Previous Topic Next Topic

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
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?
Related:

1 response

Answer 1 / 1
GeekPeek Posts 115 Registration date Tuesday June 30, 2020 Status Member Last seen June 30, 2021 41
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.
1

Similar discussions

Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
How do i change date format in (dd.mm.yyyy)
Talha -
Catherine -

6 responses
How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Excel format
D -
sheryljohnson -

1 response
What shall i do after formatting my laptop?
upen91 -
jack4rall -

1 response