date format

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i want to convert date into normal american style.

i am importing date from text file where
date is coming in this format(in three different column cells).

11 Apr 7

Required result in one column cell 04/11/2007.

can anyone help.
 
One approach that may work, assuming the data is in A1:C1,

=DATE(2000+C1,MATCH(B1,{"jan","feb","mar","apr","may","jun","jul","aug","sep","oct","nov","dec"},0),A1)
 
Hi

Try
=(A1&B1&C1)+0
Format the cell with the Date layout you want
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

countifs Function not giving desired result with date criteria 2
Which is the best MBOX Converter Tool different formats conversion? 4
separating date and time 5
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
Comparison of columns using Conditional Formatting 3
Month (MMM) from date (dd/mmm/yy) 1
Date format problems after csv import 2
Complicated Cell Formula 9

Back
Top