Okay, Mark.
If you do a lot of adding course ID's you probably know that you should create a macro in Excel that can help. The macro might include the other edits that you find yourself always making.
Do you really want to change a "-" to a "0"? Would it make more sense to change a "-" to a "blank", which could become a "null" in your Access database? (Just a suggestion.)