Hi. It doesn't work for me. I have here the date format which is mm/dd/yyyy but my question was ~ How can I display this format without this "/" sign so it would be displayed like this "mmddyyyy". I tried your formula but it displays like this "mdyyy". So what's the problem with my formula? Help me pls. ...