I’m trying to take the left two characters from a date (10/1/99, for example) and put them in a separate column so it would read “10”. However, EXCEL is reading it as a Julian number (36434) and it is returning “36” to the column instead. Does anyone know how fix this so it just reads the “10”?
Thanks!
