Solved i want to format 930 into 9/30 in excel

January 10, 2014 at 05:40:44
Specs: Windows 7
all attempts with formulas change output to 7/18
or 7/18/1902
its odd all I'm looking to do is take 3 or 4 numbers #### and format them to MM/DD
but its not working as expected

See More: i want to format 930 into 9/30 in excel

Report •

January 10, 2014 at 19:29:42
✔ Best Answer
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.

Report •
Related Solutions

Ask Question