My Account
Sign up, and you'll be able to ignore users whose posts you don't want to see.
Sign up
Report problem with this ad
Start a related thread
Start a related poll
Reply via Boardmail
Apr 19, 2021
3:04
:51
pm
NottherealJWill
Contributor
I think the quote is there because there’s a weird format that’s being used
If he changes to the basic one I mentioned then it should be fixed.
Start a related thread
Start a related poll
Reply via Boardmail
Report problem with this ad
NottherealJWill
Bio page
NottherealJWill
Joined
Dec 2, 2015
Last login
Apr 25, 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
Cachanilla83
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