i have attach one file , which contain 1st colume is the combination of date and time.at 1st half containe - formate of date after that it is / formate.so, i want to how to convert all date into - formate and what is the system os formate for date and time.
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
change the format of excel sheet
0
Answers
1
Hi,
I think you want to separate Date and Time of column 1st column and this attachment may help you.
Update
=TEXT(A2,"DD-MMM-YYYY")=TEXT(A2,"HH:MM:SS")Discussion
I posted the formulas that you used so it would be easier for other users to see them. (Makes it easier to find the solution this way.)
don (rep: 1989) Jan 6, '17 at 3:17 am