Use the Stratigraphy Types Table's Edit | Renumber Stratigraphy Order option to reset the numbers in the Order column to sequential integer order, based on the current number sequence. This can be helpful if you have missing numbers or decimal values in the list.
RockWorks will number the existing formations from 1 to n based on the current Order within the table, where n is the number of formation names listed.