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

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

Thanks, just in case anyone else is reading this the currency symbol, in
this case pound sign replaces the A3 that somehow appears in this
thread. Formatting - Yawn. Thanks again!


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