How to set number/text format in Excel or PPT datasheet cells?
Posted on 2006-06-22
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.