Setting Cell Type From Word Macro

[IWT]

Hi,

I'm writing a macro in Word that copies some data over from Word and
puts it into an Excel spreadsheet.

My question is, how do you define the type (e.g. text/number/date etc)
of a cell in Excel. I have some values with an undefined number of
leading zeros so would like to define them as text instead.

Many thanks,

Tom

 

[Guest]

You could concatenate an apostrophe as a prefix character to the values with
leading zeroes to convert them to text.