+ Reply to Thread
Results 1 to 3 of 3

Copy/Paste percentages into an email

  1. #1
    Forum Contributor
    Join Date
    05-27-2012
    Location
    New Brunswick, Canada
    MS-Off Ver
    Excel 2016
    Posts
    327

    Copy/Paste percentages into an email

    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
    Please Login or Register  to view this content.

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643
    Try using Text for all the ranges.
    If posting code please use code tags, see here.

  3. #3
    Forum Contributor
    Join Date
    05-27-2012
    Location
    New Brunswick, Canada
    MS-Off Ver
    Excel 2016
    Posts
    327

    Re: Copy/Paste percentages into an email

    I don't know why I didn't think of that! Thanks again Norie! You solved two for me since I've started on this forum

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1