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

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

Report problem with this ad

Apr 19, 2021
3:00:55pm

Indy Coug Loquacious Lummox

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

Report problem with this ad

Indy Coug

Bio page: Indy Coug
Joined: Dec 20, 2001
Last login: May 5, 2024
Total posts: 184,844 (9,838 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