View Single Post
  #2   Report Post  
CyberPhix
 
Posts: n/a
Default

Your Dates are Dates, not Text, Your attempting to use a
Text Function, try =text(f2,"MM")

-----Original Message-----

I am getting these results in column E for this function
=left(F#,2).
results
col E col F
row2 38 6/28/2005 e.g., left(f2,2) is 38
row3 37 11/27/2002 e.g., left(f3,2) is 37
row4 37 6/23/2003 e.g., left(f4,2) is 37
row5 37 5/15/2003 e.g., left(f5,2) is 37
row6 38 1/26/2004 e.g., left(f6,2) is 38
row7 37 12/5/2003 e.g., left(f7,2) is 37

Can you tell me why this function would return these
results in column E.

.