How to Convert 24/03/2010 as text into 03/24/2010 date format

  • Thread starter Thread starter Nitesh
  • Start date Start date
N

Nitesh

Hi ,

I’m using Ms Excel 2003 and in my excel sheet there is a column in which
dates are entered as DD/MM/YYYY (e.g. 24/03/2010 as a text) format and I
wanted to convert it into MM/DD/YYYY (e.g. 03/24/2010).

Can excel programming is required to convert such date or is there any excel
function.

Please suggest.
 
hi
you could use text to columns
high light the date.
on the menu bar>data>text to columns
step 1 - select delimited, click next
step 2 - select tab, click next
step 3- upper right "column data format", select date.
from the drop down, select DMY, click finish.

regards
FSt1
 

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

Convert 24/03/2010 date into 03/24/2010 date format 3
Arranging dates in a single column 5
Date format problems after csv import 2
separating date and time 5
Formula to display nearest following Thursday in mm/dd/yyyy format 1
Counting Occurrence of a Value within Cells 1
change date from 20-Mar-1920 to 20/03/1920 format 5
Month Function on UK dates formats (dd/mm/yyy) 2

Back
Top