Thread: Can excel convert a date to text
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default Can excel convert a date to text
=YEAR(B3)+DAY(B3)*10000+MONTH(B3)*1000000 and format as general
--
Gary''s Student - gsnu200793


"Hamed parhizkar" wrote:

If in cell B3 i have a date in this format: 6/27/2008. Is there anyway that I
could put a formula in a cell F2 that makes my output read 62708 or 6272008?
Reply With QuoteReply With Quote