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.