On one of my reports, I have to enter in several order numbers. The order numbers all start with the same thing, but end in different numbers. example: "XXX-XXXXX-12345-..." where the "..." represents the identifying number.
Is there a way to change what the cell shows by entering in the identifying number only? So I just want to be able to enter in "9876" and it will automatically print "XXX-XXXXX-12345-9876."