I have a macro that takes a value from an excel spreadsheet and insert
it into a work document at a bookmark. The number is a currency and I'
like it to be entered in the work document in this format.....

£xx,xxx,xxx.xx rather than £xxxxxxxx.xx which is what currentl
happens, the script I am using is this...

appWD.ActiveDocument.Bookmarks("ValueNumber").Rang e
Format(strValueNumber, "£0.00")

'strValueNumber is from the excel spreadsheet
'ValueNumber is the bookmark in the word document

How would I (if it's possible) modify this to add the commas in

--
ChrisMattoc
-----------------------------------------------------------------------
ChrisMattock's Profile: http://www.excelforum.com/member.php...fo&userid=3391
View this thread: http://www.excelforum.com/showthread.php?threadid=54704