How can I apply the General or text format to the cell in VBA? I know how to
do it on the excel spreadsheet by formatting the cell, but I'm creating the
column just before I run this loop. So I'd have to format it then.

"Bob Phillips" wrote:

Looks like your target cells are formatted as dates. Change to General.

--
HTH

Bob Phillips