Thread: Conversion of date into different format
View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default Conversion of date into different format
One more formula...
=--text(a1,"0000\/00\/00")
Format as a date.



"Fam via OfficeKB.com" wrote:

can date 20060625 be converted into 06/25/2006?
Any help will be appreciated.
Thx

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200607/1

--

Dave Peterson
Reply With QuoteReply With Quote