Date format nightmare [Solved/Closed]

Question

Previous Topic Next Topic

Date format nightmare [Solved/Closed]

Report

Webill

Posts: 2
Registration date: Friday February 5, 2016
Status: Member
Last seen: February 5, 2016

- Feb 5, 2016 at 07:42 AM
xpcman

Posts: 19532
Registration date: Wednesday October 8, 2008
Status: Contributor
Last seen: June 15, 2019

- Feb 5, 2016 at 01:16 PM

solved with this:

Because it is not a date to excel.

1. Select the column in which there was date
2. Goto data and choose text to column
3. choose delimited and click next
4. uncheck all and click next
5. click on date and choose right data format of the date that you currently have. It seems that you have DMY, Chose that and finish

This will transform the cells to date

Now format the date as you wish

Date format nightmare
How to change date format in excel to dd/mm/yyyy - How-To - Excel
Format write protected usb - How-To - USB
How to change time format in whatsapp - How-To - Mobile
Formater cle usb mac - How-To - USB
Instagram password format - How-To - Instagram

1 reply

Ask a question

xpcman · Answer 1 · 2016-02-05T13:16:58-0500

Answer 1 / 1

xpcman

Posts: 19532
Registration date: Wednesday October 8, 2008
Status: Contributor
Last seen: June 15, 2019

1,824
Feb 5, 2016 at 01:16 PM

thanks for the tip

Date format nightmare [Solved/Closed]

1 reply

Your reply

Subscribe To Our Newsletter!