Use the number format function to change the date format

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

Report problem with this ad

Apr 19, 2021
2:54:28pm

NottherealJWill Contributor

Use the number format function to change the date format

Report problem with this ad

NottherealJWill

Bio page: NottherealJWill
Joined: Dec 2, 2015
Last login: Apr 23, 2024
Total posts: 981 (14 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