change the format of excel sheet

0

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.

Answer
Discuss

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")
Discuss

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: 1482) Jan 6, '17 at 3:17 am
Add to Discussion

Answer the Question

You must create an account to use the forum. Create an Account or Login