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