I believe the function You should use is: xlRangeFormatNum()

To format a total column, range should be eg. 'A:A'

Example to format column A as Text:

$rc = xlRangeFormatNum($xlPtr, "A:A", "Text",,'Sheet1')

-Erik