Date Formatting

[Iris Stein]

I am unable to format the dates in these two columns attached. I've tried formatting, using Text to Columns and using left, mid formulas but haven't been able to find a solution for this. Can anyone suggest another method?

 

[NARAYANK991]

Hi ,

Can you mention what your system ( Windows OS ) date format is ?

Narayan

 

[Iris Stein]

I am using US format. I would like a format like this:

2016-07-10 05:00:28
YYYY MM DD HH:SS

 

[Marc L]

Dates can be formated only if they are numbers
but many of your cells are texts !
​

 

[NARAYANK991]

I am using US format. I would like a format like this:

2016-07-10 05:00:28
YYYY MM DD HH:SS

Hi ,

What does US format mean ? Is it mm/dd/yyyy ?

Narayan

 

[Iris Stein]

I don't really mind the exact format. Is there a way to format them all into dates? I tried several methods, but was unsuccessful.

I would appreciate any suggestions.

Thanks in advance,

Iris

 

[NARAYANK991]

Hi ,

I think I have not been able to communicate.

If your system format is mm/dd/yyyy , the formula which will need to be used to convert the data into valid dates will be different from the formula which will be needed if your system date format were dd/mm/yyyy.

I need to know what your Windows OS date format is ; is it mm/dd/yyyy or is it dd/mm/yyyy ?

Narayan

 

[Iris Stein]

It is mm/dd/yyyy

 

[NARAYANK991]

Hi ,

See if this is OK.

Narayan

 

[Iris Stein]

Very helpful, thanks!