Changing Number to Percentage format

[Niraj Baraili]

Hi Experts,

Just tried to change the number to percentage format as below for the number 1.4

Selection.Numberformat="0.0%"

I am getting final value as 140% instead of 1.4%.

Any idea ?

 

[vletm]

1.4 = 140%
0.014 = 1.4%
and You can test both
My Excel version's results are
"0.0%" gives 140.0% and
"0,0%" gives 140%

 

[Niraj Baraili]

Hi Vletm,
Thanks for the tips. I just tried. It didn't work.
My values are like this...
1.2
3.5
6.8
1.9
2.1
After converting, it should look as below:

1.2%
3.5%
6.8%
1.9%
2.1%

 

[Chihiro]

First divide the number/value by 100 then apply the format.

 

[Niraj Baraili]

Thanks Chihiro.