VBA Language to convert whole number to percentage

[NinaE_11]

Hi,
I'm setting values in one spreadsheet from another using the following code:

Workbooks("Template_VBA.xlsm").Worksheets("Char").Range("E11").Value = _
Workbooks("Characteristics.xlsx").Worksheets("Active").Range("B37").Value

The original value in B37 on the "Active" worksheet is a whole number of 29.3, which I need to reflect as 29.3% in the destination worksheet ("Char"). I have a whole page of these I need to convert over into these percentages for a presentation using the below code, however, whatever I'm doing is giving me a result of 2930%.

With Range("E11")
.Value = .Value / 100
.NumberFormat = "0.0%"
End With

Anything help would be great - thank you!

 

[Joe4]

It works just fine for me, if cell E11 is hard-coded and not a link/formula.
If it is a link/formula, you will need to update your formula to divide by 100.

Why not just do:

Workbooks("Template_VBA.xlsm").Worksheets("Char").Range("E11").Value = _
    Workbooks("Characteristics.xlsx").Worksheets("Active").Range("B37")/100

and then you can format the range.

 

[NinaE_11]

What exactly is in cell E11?
Is it hard-coded, or is it a formula?
If it is a formula, you will need to update your formula to divide by 100.

The number is cell E11 is hard-coded, downloaded from an external source.

 

[Joe4]

Sorry, you were too quick and replied while I was making edits to my previous post!
Take a look at the revised suggestion.

 

[NinaE_11]

Sorry, you were too quick and replied while I was making edits to my previous post!
Take a look at the revised suggestion.

Outstanding!! Thank you SO much!

 

[Joe4]

You are welcomne.
Glad it worked for you.