-
Import data from excel to powerpoint(% not showing)
Sir,
I need some help.
I want to import data from excel sheet which contains % ie 2%, 4%, .....( in column B)
but when import to powerpoint through vba it display as 0.02, 0.04 (not in 2% or 4%).
How it should display as 2% or 4%?
tbhm = GetObject(filepath).sheets(1).Range("B2:B6")
Application.Presentations(1).Slides(1).Shapes("Population").TextFrame.TextR ange.Text = tbhm(6, 1)
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules