how do I change date from mm/dd/yyyy to dd:mm:yyyy format in Excel Jack Wilson 17.07.2006 22:11:02 I have a spreadsheet that the data, the date was input in Excel 2003 as mm/dd/yyyy (12/31/2004), how can I convert the column of cells format to "dd:mm:yyyy"(31:12:2004)? I tried to change date format from "Format Cells----choose "date" or "custom" and tried different options, but they wouldnt change the data already in the cells. I have a spreadsheet that Microsoft is requesting information in dd:mm:yyyy (yes colons) format. Thanks Jack

Re: how do I change date from mm/dd/yyyy to dd:mm:yyyy format in Excel VBA Noob <VBA.Noob.2b42x9_1153176313.3867[ at ]excelforum-nospam.com> 17.07.2006 22:41:32 How about =TEXT(SUBSTITUTE(E1,":","/"),"dd/mm/yy") assuming date in E1 VBA Noob -- VBA Noob ------------------------------------------------------------------------ VBA Noob's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=33833 View this thread: http://www.excelforum.com/showthread.php?threadid=562255

Re: how do I change date from mm/dd/yyyy to dd:mm:yyyy format in Excel Dave Peterson <petersod[ at ]verizonXSPAM.net> 17.07.2006 23:18:09 How about a custom format of: dd\:mm\:yyyy Jack Wilson wrote: [Quoted Text] > > I have a spreadsheet that the data, the date was input in Excel 2003 as > mm/dd/yyyy (12/31/2004), how can I convert the column of cells format to > "dd:mm:yyyy"(31:12:2004)? I tried to change date > format from "Format Cells----choose "date" or "custom" and tried different > options, but they wouldnt change the data already in the cells. I have a > spreadsheet that Microsoft is requesting information in dd:mm:yyyy (yes > colons) format. > > Thanks > > Jack -- Dave Peterson

Re: how do I change date from mm/dd/yyyy to dd:mm:yyyy format in Excel SteveW <sj_walton[ at ]nothotmail.com> 18.07.2006 07:55:57 What you've done should work Don't forget it wont change the data. So if you click on one of the date cells it will still say 12/31/2004 But the format will display the date on screen/print as you want. Steve On Mon, 17 Jul 2006 23:11:02 +0100, Jack Wilson <Jack = <Wilson[ at ]discussions.microsoft.com>> wrote: [Quoted Text] > I have a spreadsheet that the data, the date was input in Excel 2003 a= s > mm/dd/yyyy (12/31/2004), how can I convert the column of cells format = to > "dd:mm:yyyy"(31:12:2004)? I tried to change date > format from "Format Cells----choose "date" or "custom" and tried = > different > options, but they wouldnt change the data already in the cells. I have= a > spreadsheet that Microsoft is requesting information in dd:mm:yyyy (ye= s > colons) format. >

RE: how do I change date from mm/dd/yyyy to dd:mm:yyyy format in Excel Jack Wilson 18.07.2006 12:57:02 Thanks to all for the replies. I appreciate it. -Jack "Jack Wilson" wrote: [Quoted Text] > I have a spreadsheet that the data, the date was input in Excel 2003 as > mm/dd/yyyy (12/31/2004), how can I convert the column of cells format to > "dd:mm:yyyy"(31:12:2004)? I tried to change date > format from "Format Cells----choose "date" or "custom" and tried different > options, but they wouldnt change the data already in the cells. I have a > spreadsheet that Microsoft is requesting information in dd:mm:yyyy (yes > colons) format. > > Thanks > > Jack > >