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

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

Hi Tim,

Use following example :

For k = 1 To 200
CellVal = ActiveCell.Value
ActiveCell.FormulaR1C1 = "=" & CellVal & "/100"
ActiveCell.Offset(1, 0).Select
Next k

HTH
Cheers
Carim

something like this would work without doing the selects

For k = 1 To 200
For Each cell In Range("A" & k)
cell.Value = cell.Value / 100
Next
Next

--


Gary


"Carim" wrote in message
oups.com...
Hi Tim,

Use following example :

For k = 1 To 200
CellVal = ActiveCell.Value
ActiveCell.FormulaR1C1 = "=" & CellVal & "/100"
ActiveCell.Offset(1, 0).Select
Next k

HTH
Cheers
Carim