Treat Numbers As Text?

I tried formatting the numbers to "text" and still got undesirable results.

Below is the data I have. The numbers on the left are part numbers and the numbers on the right are the times they're used. I would like the part numbers to be on the x axis and the times they're used (73, 42, etc.) to be on the y axis. Pretty simple right? Change the part numbers to text, highlight both columns and insert a column chart, piece of cake.

Instead what is actually showing is a series of "1 - 9" on the x axis and a range from 0 - 50,000 on the y axis which it thinks the part numbers are even though I have them formatted as text.

490125
73

221261
42

490189
42

[Code] ........