this one’s on the left that’s how you can tell the difference now if you don’t want to do it by hand completely manually and waste hours of your time you can do it in a very simple way so we’re going to do text so this is the exact formula that we’re going to use so let’s get rid of that one there we go so we’re going to do equals we’re going to do oops text it says converts a value to text in a specific number format so for a date format we can choose a date format and then it’ll convert it to a text for us which saves so much time i promise you let’s do all of these just like we did and then we need to tell it what the format is if we don’t if we tell it something incorrect it’s going to give us a completely terrible output or just give us an error altogether so this is a day month month year year year year format and that is what we’re going to do so we’re going to dd slash mm yyyy