Sign up, and CougarBoard will remember which categories you want to view. Sign up
Apr 19, 2021
2:53:17pm
ChiCityCoug All-American
Excel question:
Right now I have a date in the following format: '01.01.2021

How do I get the text indicatory (the apostrophe) removed?

Or better yet, how do I get the full date to be in the following format: 1/1/2021

I have tried to use text to columns, changing the format, and using the "right" function to try and get rid of it, and search and replace but the apostrophe is not searchable.
ChiCityCoug
Bio page
ChiCityCoug
Joined
Sep 11, 2016
Last login
May 11, 2021
Total posts
3,693 (2 FO)