I copy stats from websites and paste them into Excel, and often the stats come in the form of x-y, as in x out of y. My goal is to use text to columns to create one column for all x's and another for all y's.
But if I'm pasting in 7-12, Excel converts it to July-12, and I don't know how to convert it back, or stop it from happening in the first place. Anyone know how to end this monstrosity? Thanks in advance.
But if I'm pasting in 7-12, Excel converts it to July-12, and I don't know how to convert it back, or stop it from happening in the first place. Anyone know how to end this monstrosity? Thanks in advance.