I know little about excel and am using it for a project for my practimum. I have a full row of dates in this format 13-Jul-17, and I want them all to go to the format 20130717. Can I do this swiftly?
I know little about excel and am using it for a project for my practimum. I have a full row of dates in this format 13-Jul-17, and I want them all to go to the format 20130717. Can I do this swiftly?
Are the dates dates, or text that looks like a date? What is the cell formatting? Date or general or something else? What happens when you change the formatting to number?
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
I think they are dates. I'm sorry but i'm fairly noob to excel.
The row says
14-Jul-13
and the upper box for working in it says
7/14/2013
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks