Convert Percentage to number

[steer.tim]

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

 

[Guest]

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

 

[Carim]

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

 

[Gary Keramidas]

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