format data

[cat3appr]

hello, i have a date expressed as YYYMMDD 20171023 and I want it as DDMMYYYY , 23102017 , how to do this?

thanks!

[cat3appr]

actually as 23.10.2017

[Ravisca2003]

Select the field(s) where the date format need to be changed.
Then press Ctrl+1

Then do the setting of format as "Custom" and format as DD.MM.YYYY.

Refer screenshot .

Add reputation and mark as solved if understood. Hope this helps.

Untitled picture.png

[63falcondude]

See post #2 from your other thread.

https://www.excelforum.com/excel-gen...ml#post4770067

[cat3appr]

sorry doesn't work for me...
can you upload an actual xls with the formatted date before and after... this is what i get after doing exactly what you said:

please, an actual xls... i'm not lucky with general instructions today

Screenshot - 24_10_2017 , 20_55_30.png

[cat3appr]

See post #2 from your other thread.

https://www.excelforum.com/excel-gen...ml#post4770067

that one refers to a time HH:MM:SS i need day, month year...
i guess is straightforward for most of people, just not for me

[63falcondude]

I was referring to the second part of post #2.

[cat3appr]

I was referring to the second part of post #2.

please if you can help uploading the xls with the working formatting i will appreciate.

[AliGW]

If you want such help, please attach the workbook.

You have so many different threads open at the moment that it is getting really difficult to keep up with everything.

[AlKey]

@cat3appr
Just to make it clear: You cannot format "dates" like 20171023. You can only format dates when they presented as a serial number 43031

[63falcondude]

Going off of what AlKey said, you cannot format a number such as 20171023 into a valid date.

That being said, what you can (and should do) is convert it to an Excel recognized date and then format it however you'd like.

I usually use Text to Columns to convert numbers into actual dates.