If Decimal Found then move the data from after decimal to before decimal

Hi Experts,

I am looking for a macro that will do the the things mentioned below
Macro will be placed in a macro.xlsm
macro.xlsm & 1.xls both are located in different path so the path should be hardcoded in the macro, so i can change it as per my needs


In column K, If after decimal if the second digit is 0 then Move all the data from after decimals to before decimals
K2 has data that has the second number after decimal is 0, so the output would be in K2 10030.00


Thnx For the Help
https://excelfox.com/forum/showthrea...4821#post14821

I don't fully understand what you are trying to do. Based on the two examples and the brief description given, it looks to me like you want to multiply column K by 100.

If that is correct, without using VBA, you could enter 100 into a cell -> copy that cell to clipboard -> select column K -> paste special -> multiply. An equivalent process should be fairly straightforward in VBA -- if VBA is required.

That's just a guess. If that's not correct, then I think we need a better explanation of what you need to do.

This is what the macro recorder gave me for that process:

Please Login or Register  to view this content.

If it is working correctly, I see no need to change it. If you are interested in learning how to "tidy up" recorded macro/VBA code, you might review these two essays:
http://www.tushar-mehta.com/excel/vb...rder/index.htm
https://peltiertech.com/how-to-fix-a-recorded-macro/