Re: How to Format Numeric Values in Bookmarks in Word Doc.

<<
Now I also tried to format them with "$ #,##0.00" , with that it
helped a bit because now they have $ sign but they are still not right
aligned:


If you use a decimal tab between the $ and the # , e.g. using

\#"$,<tab>0.00"

where <tab> is actually just a tab character, and set the appropriate
decimal tabs in the paragraphs the numbers appear in (or if possible, in the
paragraph style), then you should get the layout you want.

Peter Jamieson


<hareshusa@xxxxxxxxx> wrote in message
news:1143907622.557967.147470@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi All,

I have a Word template with Bookmarks in it. I have linked that to an
Excel work*** (which has my data) and I am populating Bookmarks on
the Template with VBA Code
based upon some conditions.

The data is already formated in Excel Work*** but when I place them
in Bookmark, they loose the format.

The Numeric data in Excel cell are formated as "Accounting" type with 2
decimal places.

eg : $ 2,345.90 | $ 137,700.38

But when they are placed in Bookmarks, I only see them as :
137700.38
2345.90

So as you can see the $ sign is lost and they are not right align as
numeric fields should be.

Now I also tried to format them with "$ #,##0.00" , with that it
helped a bit because now they have $ sign but they are still not right
aligned:

They show like:

$ 137,700.38
$ 2,345.90

So they are not align the way I want them. I want to see them as:
$ 137,700.38
$ 2,345.90

Is it possible? any help would be really appreciated.

Many Thanks,
HJ



.

Loading