Divide Integer/Decimal inside one cell

I'm a complete VBE novice and can't seem to figure this one out.

I have two percentages that I need to divide by each other that will be entered by the user into the range H10:M100. In order to cut down on entry time the user will enter the two percentages in the format ##.##, where the integer value is one percentage and the decimal value is the other.

I then want a macro to split the two values, integer and decimal, and divide the percentage represented by the decimal value by the percentage represented by the integer value. I want the result to be displayed in the same cell that the information was entered into as an integer only percentage.

For example, if 45.25 was entered into a cell in the H10:M100 range excel would perform the following actions:

Split 45.25 into .45 and .25
divide .25 by .45 = .5555555555
report back in the same cell 56%

45.45 would return 100% and so on.

I've hit roadblocks every time I try to program it but I know its a simple action and somebody here can help me.

Any help is appreciated. Thanks.

I appreciate the help. It's exactly what I need with one exception.

In the case that the two involved percentages were 10% and 5% I would like to be able to enter them as "10.5" rather than "10.05". Or in the case where the two percentages were 75% and 150% they would be entered as "75.150".

Your macro handles any two digit percentages perfectly but returns incorrect results for anything outside that (I probably misled you in the original post when I said numbers would be entered in "##.##" format). Can your code be tweaked to handle 1 digit and 3 digit percentages on either side of the decimal point as well? That would cover any number that would ever be entered into the affected cells for my use.

Unfortunately even tweaking your programming to handle that is beyond my ability.

Again, thanks for your help.

The only reason why I used a decimal point is because it's easy access from the Numpad. I could use anything. What would the code look like if it used a comma?

Hmm. No dice with this new program. No errors but it doesn't seem to do anything. Does it test properly for you?

Thanks for the effort.