Thread: extract year from the date in a cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DKY
 
Posts: n/a
Default extract year from the date in a cell

I have a cell with 01/01/2006 in it, and I'm trying to extract the 2006
but when I put =Left(b9,4) it returns 8718.
I'm also trying to pull the 2006 and put spaces in between it like so
2 0 0 6

Does anyone know how to do these two things?


--
DKY
------------------------------------------------------------------------
DKY's Profile: http://www.excelforum.com/member.php...o&userid=14515
View this thread: http://www.excelforum.com/showthread...hreadid=523216

Reply With QuoteReply With Quote