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
Bookmarks