Formatting Date

Question

Formatting Date

Report

Moselley - Nov 27, 2020 at 06:06 AM
GeekPeek

Posts: 78
Registration date: Tuesday June 30, 2020
Status: Member
Last seen: December 3, 2020

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

Formatting Date
How to change date format in excel to dd/mm/yyyy - How-To - Excel
How to format write protected usb - How-To - USB
Formater cle usb mac - How-To - USB
How to change time format in whatsapp - How-To - Mobile
Phone format code - How-To - Android

1 reply

Reply Ask a question

GeekPeek · Accepted Answer · 2020-11-30T04:22:03-0500

Answer 1 / 1

GeekPeek

Posts: 78
Registration date: Tuesday June 30, 2020
Status: Member
Last seen: December 3, 2020

39
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.

Formatting Date

1 reply

Your reply

Subscribe To Our Newsletter!