?odd results for =left(F#,2)
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. |
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. . |
All times are GMT +1. The time now is 05:12 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com