Forum Discussion
Convert Text to specific numbers
I have the data below: This is an attendance record. The data in the cells need to be converted into certain numbers as shown below: ...
I'm going to assume you just need to do this once and from here on out will enter the numbers that you want, although the method I'm going to tell you about will continue to work. But why enter P when you mean 1.5 in the first place, right?
Using the main menu, click on Edit
and then down to Replace
And then in the Dialog box that opens up fill it out as shown here and click on "Replace All"
Follow the same routine for replacing the other letters with the desired values