Search results

HI Grah I recently moved to a newer Office version. The company I work for upgraded my HDD to an SSD. The Data i pull from our System is a Sellout for the month with all our customers. I looked at a previous sellout sheet i exported to CSV and noticed the Date and Time is in a different format...

H Hi @Hui, Unfortunately this did not work either.

@GraH - Guido , @NARAYANK991 ,@shrivallabha , Thank you All for looking into it. I still haven't come right unfortunately with changing the format. as soon as i Remove the time from the cell then my formula works. I am going to use a simple Left and Right formula to retrieve the year...

@GraH - Guido Thank you for your reply. The Formula works however i get the #VALUE! Error

@Tim326515465, Thank you for your reply. I have also tried that and doesn't seem to work either. Kind Regards Callum

HI Ram, Thank you for your reply, I have checked this and it is set to Auto. Not sure why It's not working? Will keep checking thank you Callum

HI Excel Ninja's Hope you can help me, i pull reports from our system and each line date has the full time included. I usually used the =YEAR(B1) Formula to only include the year and that has worked fine. i recently moved to the latest version of office (2016 - on Office 365 E3 Plan) and now...