Percentage not carrying over.

[Destiny1990]

With the section & Range("Q2").Value & needs to pull a percentage from the sheet in question however when ever it pulls though to email it comes as a decimal number and not a percentage.

Could anyone please help me solve this. thanks.

Please Login or Register  to view this content.

[Keebellah]

Formatting is as the word says a format, when you use the value it's the actual value in that cell that is used, so if you see 100% the value is 0.1 (or 0,1 depending on the used decimal separator)
So when you want to pass values it's the value that is shown and not the formatting so you must include the formatting too.
You id that with the date value also do it with the format something like shown below,

Please Login or Register  to view this content.