Number format in word

[nowacknator]

Hi.

I am creating a macro in VB that has the purpose of importing data
from a table in Excel to a table in word. Everything is working fine,
except for the fact that I can't seem to figure out how to control the
number format like you can in Excel.

I want to be able to format the table values with thousand seperators
and write the number with a scientific notation (1.00E+07).

Is that at all possible?

Thanks.

Lasse Nowack

 

[Stefan Blom]

The easiest way is to embed the Excel sheet; that way, you can take
advantage of the Excel formatting capabilities.

In Word, you cannot specify a number format for a table cell. Instead, you
will have to format the contents by using field codes.