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

Sign up, and you can customize which countdowns you see. Sign up

Report problem with this ad

Apr 19, 2021
3:05:20pm

Cachanilla83 All-American

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

using the Date function.

This message has been modified

Originally posted on Apr 19, 2021 at 3:05:20pm

Message modified by Cachanilla83 on Apr 19, 2021 at 3:05:50pm

Report problem with this ad

Cachanilla83

Previous username: Rival Apostate
Bio page: Cachanilla83
Joined: Aug 18, 2014
Last login: May 3, 2024
Total posts: 4,706 (76 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