Challenge #303: International Bank of Awesome Data - Part II

[Michael_McKee]

Interesting, but when you don't do the D/C step, it causes some issues with the conversion.

Spoiler

 

Spoiler

 

[kelvin_law1]

Here is my solution with the extra challenge:

Spoiler

[Reesetrain2]

All,

My solution:

Spoiler

 I wasn't able to get the drop down, but everything else works.
-I used a find replace to change the comma to a decimal and get rid of the $ and the -

The workflow

Spoiler

 -Cheers!

Matt

[balajilolla1]

Spoiler

Solution Attached

[alexnajm]

Great challenge! 

Spoiler

[Qusaiamer]

First macro but couldn't run without errors- would appreciate any feedback!

[JereJussila]

Spoiler

Spoiler

Not the cleanest but does the trick!

[atcodedog05]

My take on this

Spoiler

[TonyA]

Great exercise. I kept the macro interface simple - may have to tweak it later. Let's see what Nicole throws at us next.

EDIT: changed the currency format routine.

Spoiler

[ChristinaFPE]

Spoiler

This was a good refresher of how to create a macro and I enjoyed learning about the detour tool that I used to complete the bonus part of the challenge.