Is there a way to convert a range of numbers to a pecent( eg 15 to 15%
or 0.15) in excel or vba?

I realise that I can divide it by 100 and then format the cell as
percent but I have an entire sheet of values that need to be converted
as part of an importing proceedure in VBA. I can convert each
individual number but was wondering of there was anything built into
excel that cound do this all in one go.

Any help appreciated.

Regards,

Tim