Date Formatting

[Bedford]

When downloading .csv files with a date range in a column separated as; 28/01/2018 I can't seem to change the date format to look as; January 28, 2018. I've tried copying and pasting as values, some text to column options but there doesn't seem to be an easy fix?
Any suggestions?

 

[Bedford]

Paul, you're a genius! Thank you tons....
Doug.

This will get the date value of the text string:

=DATE(VALUE(RIGHT(A1,4)),VALUE(LEFT(A1,2)),VALUE(MID(A1,4,2)))

 

[Paul Ked]

You're welcome

Cheers

 

[markmzz]

Sorry Markmzz, you've got me stumped, I'm lost as to what I'm missing with this?

I don't know what is the problem with the formula.

Here it Works.

So the important think is that your problem was solved with the Paul's formula.

Markmzz

 

[Bedford]

Markmzz, thank you for your effort, very much appreciated.

I don't know what is the problem with the formula.

Here it Works.

So the important think is that your problem was solved with the Paul's formula.

Markmzz

 

[WNSUSA]

Hi Fellas,

I need some serious help, i apologize for thread jacking.

I see someone posted a chart that shows a serious of numbers that transform to dates.

For some reason on the spreadsheets i have here that i work on, seem to convert the dates and accounting formula back to plain numbers.

Even if i put accounting back on the numbers for dollar value and put the dates back, click save and close the window on the file, i open it back and it converts everything back and reverses the changes i made. example : Date 10/4/2018 Converts to 43377.

Whats causing this? i have other billing templates that do this, is there a way to reverse this change?