|I'm confused. Your subject line says 9/30, but the body of your post says the output is changed to 7/18. Care to explain that?|
One possible solution is to put an apostrophe in front of 9/30:
The apostrophe tells Excel that what follows is text, so don't mess with it.
Another portion is to use a custom format of MM/DD
9/30 will appear as 09/30 if that's OK.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.