Probably not information to go on, but if ALL values in this column are
100 times too high then put 100 in a cell, copy it and then select the
column - now do edit paste special, and use the divide by option. IF
the rules are more complex than this, then a macro could be used