How to Format Numeric Values in Bookmarks in Word Doc.

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