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

[Kevin B]

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

--
Kevin Backmann


"IWT" wrote:

> 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
>
>