Sure, just use the format "£#,##0.00"
ChrisMattock wrote:
I have a macro that takes a value from an excel spreadsheet and inserts
it into a work document at a bookmark. The number is a currency and I'd
like it to be entered in the work document in this format.....

£xx,xxx,xxx.xx rather than £xxxxxxxx.xx which is what currently
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?


--
ChrisMattock
------------------------------------------------------------------------
ChrisMattock's Profile: http://www.excelforum.com/member.php...o&userid=33912
View this thread: http://www.excelforum.com/showthread...hreadid=547047