Change the Data Type

[Selv]

Currently, I am working on an application that opens an Excel spreadsheets
and populates it with data. However, I have been unable to find any
documentation on how to change the data type in a Cell or range. I would
like to change a cell from "General" to "Percentage" data type format from
within the VB application.

An example of the other api funcation I am using which work correctly is:

ExApp.Worksheets("Sheet1").Range("A1").Bold = True

Unfortunately, I cannot find the property name for data type, which likely
replaces "Bold".

Any help would be appreciated.

Thanks

 

[Andy Wiggins]

Selection.NumberFormat = "0.00%"

Hint: use the macro recorder.

 

[Rod Gill]

It should be Font.Bold=True. You will also get more help in the Excel vba
newsgroup: this one is dedicated to MS Project.