If the format is consistent, try the following (I'm sure there are multiple solutions)

Sign up, and you can make all message times appear in your timezone. Sign up

Report problem with this ad

Apr 19, 2021
2:55:16pm

Indy Coug Loquacious Lummox

If the format is consistent, try the following (I'm sure there are multiple solutions)

=DATEVALUE(MID(a1,2,2)&"/"&MID(a1,5,2)&"/"&MID(a1,8,4))

This message has been modified

Originally posted on Apr 19, 2021 at 2:55:16pm

Message modified by Indy Coug on Apr 19, 2021 at 3:02:27pm

Report problem with this ad

Indy Coug

Bio page: Indy Coug
Joined: Dec 20, 2001
Last login: Apr 29, 2024
Total posts: 184,767 (9,837 FO)

Report problem with this ad

Messages

Author

Time

Excel question:

ChiCityCoug

4/19/21 2:53pm

Use the number format function to change the date format

NottherealJWill

4/19/21 2:54pm

If the format is consistent, try the following (I'm sure there are multiple solutions)

Indy Coug

4/19/21 2:55pm

Why not number format (or format cells > number) > Date > Type 5 or 6?

NottherealJWill

4/19/21 2:57pm

I think the leading single quote is going to be a problem

Indy Coug

4/19/21 3:00pm

I think the quote is there because there’s a weird format that’s being used

NottherealJWill

4/19/21 3:04pm

I use the left, mid, right functions to create 3 new cells that can be combined

4/19/21 3:05pm

Thanks for the help... ended up being easier than I thought. I just did a search

ChiCityCoug

4/19/21 3:11pm

For next time: ctrl + : inserts current date and formats the cell

cougarstrong

4/19/21 3:13pm

Report problem with this ad

Posting on CougarBoard

In order to post, you will need to either sign up or log in.

Report problem with this ad