VBA To Update Column In Workbook

I am iterating a directory and want to update the data in column E to have a percent sign. I used the macro recorder and it spit out the below, which works for my current workbook, but my issue is that the number of rows with data vary from workbook to workbook. So in certain instances each row is not being updated.

How should this be changed to take ALL rows with data in row E, and perform this update?
**And if any more proficient devs see a way to reduce clutter I'm all for it **

Please Login or Register  to view this content.

Hi @jeffreybrown - if I run that syntax it converts the data from
4.2
to 420%

My desired output would be
4.2% = essentially just add the % sign to the value that already exists in E

@jeffreybrowne -
That did it! One slight tweak. If we have 2 in the cell we only want it to show 2% and not 2.0%

Is there a way to slightly alter that so it can account for only single digits being in the cell?

@6StringJazzer - Can I conditionally format the cell based off the value? Meaning if the cell contains 2.2 then it is formatted to 2.2% but if it only contains 2 then it is formatted to 2%

Originally Posted by 6StringJazzer

This will display no decimal portion, but beware that if the underlying number does have a decimal portion, it will be rounded only in the display:

Please Login or Register  to view this content.

That is, 2.0% will look like 2% and 2.2% will also look like 2%.

I have tried this - but it is giving me the 2.0% regardless.

Please Login or Register  to view this content.

I am starting to see what you want now. You had kinda sorta the right idea with your code but it is almost always preferable to manipulate numbers arithmetically rather than managing them as strings.

There are two ways to do this.

1. Use jeffreybrown's code from post #4 and also use conditional formatting, as you suggest:

=E1=MROUND(E1,0.01)

format is Percent with no decimal places

(apply to column E)

2. Do it all in the code. Modify jeffreybrown's code as shown:

Please Login or Register  to view this content.

I see you have marked this as SOLVED, but I do want to add one more thing. The way you want to display this number is contrary to the rules of significant digits and precision. The number 2% and the number 2.0% are not the same number. If you display 2%, it implies that you only know the precision to one significant digit. That is, the number could fall between 2.0% and 2.9%, but the number in the first decimal place is uncertain. Except in your case, it is in fact certain, so the displayed precision is misleading.