This function will not work for me (I am using a date). I referenced a cell with a date AND a time and I only need the date (the first 12 characters). That formula is giving me a weird output. =LEFT('Qualtrics Output'!I3,12)+0 changes nothing and =LEFT('Qualtrics Output'!I3,12) gives me 41239.525601. The referenced cell is 11/26/2012 12:36.