Excel formula question =LEFT,2 on a DATE - TechRepublic
Question
January 8, 2009 at 04:21 PM
craig.cude

Excel formula question =LEFT,2 on a DATE

by craig.cude . Updated 17 years, 6 months ago

I’m trying to get the left two characters from a date that is showing as 10/01/91,but I keep getting a Julian number of “33” instead of (10). I realize the system is reading the 10/01/91 as Julian 33512 and taking the left two numbers but does anyone know how to make it not read it as a Julian date?

Thanks!

This discussion is locked

All Comments