Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Convert 24/03/2010 date into 03/24/2010 date format
Hi ,
Im 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. -- ------------------------------ Thanks Nitesh ------------------------------ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Convert 24/03/2010 date into 03/24/2010 date format
Hi Nitesh,
Because you say the dates are entered as text you can use Text to Columns to change it to a real date and it should format the cells as dates. Select the column with the text dates. Select menu item Data - Text to columns - Fixed width - Next - Next- Date At the Date dropdown select the date format that it is in currently ie. D/M/Y Click finish. The date will now be in your regional date format and the cell formatted as Date. Now you can re-format the date using Number format to any format you want. -- Regards, OssieMac "Nitesh" wrote: Hi , Im 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. -- ------------------------------ Thanks Nitesh ------------------------------ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Convert 24/03/2010 date into 03/24/2010 date format
On Jun 5, 9:34*am, Nitesh wrote:
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. -- ------------------------------ Thanks Nitesh ------------------------------ You can use following code. Just paste the following in any standard module.Call like any other function from Function Wizard (It will be in Usedr Defined Category) Function DateConvert(dte As String, Optional sep As String = ".") Dim fstpos As Integer, sndpos As Integer fstpos = InStr(1, dte, sep, vbTextCompare) sndpos = InStr(1 + fstpos, dte, sep, vbTextCompare) DateConvert = DateSerial(Mid(dte, sndpos + 1, 50) _ , Mid(dte, fstpos + 1, sndpos - fstpos - 1) _ , Left(dte, fstpos - 1)) End Function You may use excel function Mid,Date,Right,Left but that will be a large one. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Convert 24/03/2010 date into 03/24/2010 date format
Bonsour®
"Nitesh" a écrit Im 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). select the column with dates menu datas convert at step 3 select date format DMY OK |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change date format year to another (e.g., from 1/2/2010 to 1/2/2009) | Excel Discussion (Misc queries) | |||
date format...3.1.2010 | Excel Programming | |||
how can i get the date & time format 2010/02/17 12:05 in excel | Excel Discussion (Misc queries) | |||
2010 date in Excel 2000 | Excel Discussion (Misc queries) |