Alright so I formatted the columns that I am affecting with the data flow task and now it loads properly. Here's what I have done:

1. Created a simple table called tblMoneys

1.1 Created two fields in the table called ID & Money

2. Created a personally formatted Excel file with headers ID & Money

2.1 Formatted ID column as a number with no decimal spots, data type: double precision float [DT_R8]

2.2 Formatted Money column as currency with 2 decimal spots, data type: currency [DT_CY]

2.3 Saved and closed the workbook

SSIS:

1. Source - OLB DB

2. Added a Data Conversion (although I don't think it was necessary but still used it non-the-less.

3. Destination: Excel Connection Manager

4. Ran the package

No issues with the loading to Excel, all formats were good.