Combine Two Macros

[Feedly]

Is there anyway, I can combine these two with a single shortcut? Right now, I use two different shortcuts. One for positive numbers, one of negative numbers. I don't know much programming! Anyhelp is appreciated. Thank you.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[AlphaFrog]

Please Login or Register  to view this content.

[Feedly]

Thank you. I want to be able to select multiple cells, and hit ctrl+J to activate the macro. Your code only works in the first cell.

[AlphaFrog]

Please Login or Register  to view this content.

[Feedly]

Thank you, Thank you, Thank you!! AlphaFrog.

[Feedly]

Hi, When I select an entire excel sheet and press ctrl+j, excel hangs. But if I click on the "," button in the number section on the home toolbar, the job gets done immediately (although in million format).
The macro was written to convert the numbers in Indian format.

A few rows, or cells, no problem pressing ctrl+j = works fine. But when I select an entire sheet, it hangs.

[Feedly]

The same thing happens if I select an entire column - for example highlight the entire column A, and press Ctrl+j = excel goes into a non responsive mode.

[AlphaFrog]

There is a million cells in an entire column. This will limit the cells it processes to the used range and within your selection.

Please Login or Register  to view this content.