Posted: Thu Sep 27, 2007 9:44 am Post subject: Number format in word
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).
Posted: Fri Dec 07, 2007 12:49 pm Post subject: Re: Number format in word
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.
--
Stefan Blom
Microsoft Word MVP
<nowacknator@gmail.com> wrote in message
news:1190886269.681756.198710@n39g2000hsh.googlegroups.com...
Quote:
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).
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
