Date text help

[karkas]

Hello, I know this must be easy, but my brain doesn't work right whenever I try to do this...

I have a list of dates in column B. They are formatted as text like this: 01/28/18 01:18:05

I need to convert that to mm/dd/yyyy in column C so that I can copy and paste that into another application. Its fine if it converts it to text in column C. I just need it to be able to paste the result in another application without having to manipulate every date.

I appreciate any help you can provide is greatly appreciated!

Thanks!

 

[Joe4]

Formatting does not change the underlying cell value, just what is displayed. If you want to convert it to text with no time in column C, use this formula in column C:

=TEXT(B1,"mm/dd/yyyy")

 

[karkas]

Wow, that was easy! I didn't think it would understand what to do with that. Sorry for the stupid question!

Thanks so much!

 

[Joe4]

No problem!

It can be confusing, the difference between just formatting the cell (which just changes the appearance, not the value), and the TEXT function, which changes the value to Text in whatever format you designate.