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

Sign up, and CougarBoard will remember which categories you want to view. Sign up

Report problem with this ad

Apr 19, 2021
3:11:31pm

ChiCityCoug All-American

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

and replace for all of the periods and changed them into slashes... that made it a date.

Report problem with this ad

ChiCityCoug

Bio page: ChiCityCoug
Joined: Sep 11, 2016
Last login: Apr 23, 2024
Total posts: 9,700 (20 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