Thread: how do I change date from mm/dd/yyyy to dd:mm:yyyy format in Excel
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
VBA Noob VBA Noob is offline
external usenet poster
  
Posts: 1
Default how do I change date from mm/dd/yyyy to dd:mm:yyyy format in Excel

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...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=562255

Reply With QuoteReply With Quote