I have a macro that is supposed to copy the following from a wrkbk sheet and paste it into an email. Here is what it looks like on the spreadsheet:
Calls Offered: 316
Calls Handled: 282
% to Forecast: 160%
AHT: 465.82
Service Level: 32%
Calls Waiting: 5
But here is what comes out when I run the macro:
Calls Offered: 316
Calls Handled: 282
% to Forecast: 1.60406091370558
AHT: 465.815602836879
Service Level: 0.319620253164557
Calls Waiting: 5
As you can see it is taking percentages as well as decimals (in Bold) and adding way too many decimals.
Does anyone know how to fix the issue? The cells are formatted to have 0 decimals yet it pastes all the decimal places. Now all this being said, these cell values are a result of a formula. Could this be why?
Here is the code
Bookmarks