format as percentage from cell to email

**fabrecass** · 01-25-2013, 07:11 AM

hi guys,

when the portion of the macro below takes the value from column H (i, 8) and sends it to an email it doesn't carry over the percentage format? can anyone show me how to make sure the formatting carries over to the email?

Please Login or Register  to view this content.

**TMS** · 01-25-2013, 08:00 AM

Something like:

Please Login or Register  to view this content.

Regards, TMS

**fabrecass** · 01-25-2013, 08:02 AM

forgive me, but will this not just apply to the second row in column H? i should have been clearer, it has to be the case of any value taken out of that column.

**TMS** · 01-25-2013, 08:10 AM

Yes, it's just an example of using TEXT to format a cell.

Where I put "Cells(2, 8)", you need to change it to ".Cells(i, 8).Value"

So your string becomes:

Please Login or Register  to view this content.

Regards, TMS

**fabrecass** · 01-25-2013, 08:25 AM

Thank you sir!!!!!!!

**TMS** · 01-25-2013, 08:26 AM

You're welcome.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.