<div>
Yes! We have a winner. &nbsp;Worked perfectly. &nbsp;Thanks a bunch.
</div>


Yes! We have a winner.  Worked perfectly.  Thanks a bunch.

<div>
<div class="content wysiwyg-content">
Hello all,<br />
<br />
I have a chart in MS PowerPoint. &nbsp;The chart is an actual chart with a datasheet, not just a pasted in image. &nbsp;A VBA macro updates the datasheet with data for the chart. &nbsp;But when it inputs a number range like &quot;3 - 10&quot; in the column header row of the datasheet - the row that holds the titles of the columns - PPT is then applying a data ormat to them and on my chart &quot;3-10&quot; becomes &quot;10-March&quot;.<br />
<br />
So I want to explicitly set the format of the datasheet cell to &quot;text&quot;. &nbsp;But I can't find the right code. &nbsp;I assume t's the samew as for Excel, as I 've found that it usually is.<br />
<br />
Anyone kow?<br />
<br />
Thanks.
</div>
</div>


Hello all,

I have a chart in MS PowerPoint.  The chart is an actual chart with a datasheet, not just a pasted in image.  A VBA macro updates the datasheet with data for the chart.  But when it inputs a number range like "3 - 10" in the column header row of the datasheet - the row that holds the titles of the columns - PPT is then applying a data ormat to them and on my chart "3-10" becomes "10-March".

So I want to explicitly set the format of the datasheet cell to "text".  But I can't find the right code.  I assume t's the samew as for Excel, as I 've found that it usually is.

Anyone kow?

Thanks.

How to set number/text format in Excel or PPT datasheet cells?

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.