In that case I'd use VBA:

Code:
[A1:A20]=[A1:A20/100]