adding %

[Boris7265]

Hello ,

I need to add % to numbers in column G , I, E and C .
nOW is 3.4, 5.3 and I would like to have 3.4%, 5.3% and so on.
I can not do fromating due to itis already % calculated .
I wrote simple macro to do it , but it doesn't work

Macro Boris
Dim Gomel As String

Gomel = "%"

Set R = Range("G1:G" & Range("G1").End(xlDown).Row)
For Each cell In R

Cells.Value = Cells.Value + "%"


Next
Would anybody point out what wrong with it ,rEAlly apreciate.

Best Reagrds,

BorisGomel

 

[cstimart]

I think Format(Cells.Value, "#.#%") should work

 

[Bieli]

It should be

cell.Value = cell.Value & "%"

 

[shg]

In the alternative, you could put 100 in a cell, copy it, select the cells to be converted, the do Paste Special and tick Divide and Values. Then format the cells as %.

 

[Boris7265]

Thank to all of you.

Really appreciate your help.

Best Reagard,

BorisGomel