Sorting Text That Contains Numbers

I am attempting to sort a list of movies by their title. I'm having trouble properly sorting those that contain leading numbers. This is what I'm getting:

12 Angry Men
12 Monkeys
2 Days in Paris
2011: A Space Odyssey
25th Hour
28 Days Later
300
40 Year Old Virgin

What I want is:

2 Days in Paris
12 Angry Men
12 Monkeys
25th Hour
28 Days Later
40 Year Old Virgin
300
2011: A Space Odyssey

It appears to be sorting by the first digit only and ignoring the rest. When sorting letters, it reads every consecutive letter, which is the proper way to alphabetize. How do I get it to do the same with digits?

Thanks in advance.

Thanks for the formula, however I do need a more simple way of doing this, if one exists. Is there any way to format the cells themselves to achieve this and avoid using formulas or additional columns?