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").Range = 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?