One way:

Put 100 in an empty cell and COPY
Select cells to be converted
EDIT==Paste Special==(Operation)==Divide
Clear cell with 100
Reformat cells to % if required

(test data first!)

HTH

" wrote:

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