Excel - Word Link - Formatting

[Scrappy666]

Hi Everyone,

I'm officially sick, i've been looking into the below problem for hours and can't find the solution.
I hope someone can help!

I am trying to link excel to word.
I have copied the cell > moved to Microsoft Word > Paste (link and merge formatting)
The data in the cell = (2,950,430)

I would like for this number to appear in word as -£2,950k (rounded to the nearest thousand).
I am using Alt-F9 to get the below:

{LINK Excel.SheetMacroEnabled.12 "\\\\FS1\\TourOperations\\HTOL Finance\\Finance Team\\MACS\\YE OCT-16\\05. March 2016\\1. MACS\\1. HTOL_MACs P&L BS Mar 16.xlsm" "1. P&L!R10C6" \a \f 5 \h  \* MERGEFORMAT}

I am part way to my goal, i have managed to change the format to include the -£, however it won't round to thousands!
If anyone has any experience in this could you please help.
Any advice is appriciated!!!

My amended formatting code is:

{LINK Excel.SheetMacroEnabled.12 "\\\\FS1\\TourOperations\\HTOL Finance\\Finance Team\\MACS\\YE OCT-16\\05. March 2016\\1. MACS\\1. HTOL_MACs P&L BS Mar 16.xlsm" "1. P&L!R10C6" \# "-£#,##0," MERGEFORMAT}

Thank you,
Daniel.

 

[Macropod]

First, delete ' \# "-£#,##0," MERGEFORMAT ' from your LINK field.
Second, select your LINK field and press Ctrl-F9 to embed it in another field, thus:
{{LINK Excel.SheetMacroEnabled.12 "\\\\FS1\\TourOperations\\HTOL Finance\\Finance Team\\MACS\\YE OCT-16\\05. March 2016\\1. MACS\\1. HTOL_MACs P&L BS Mar 16.xlsm" "1. P&L!R10C6"}}
Third, edit the outer field, thus:
{=({LINK Excel.SheetMacroEnabled.12 "\\\\FS1\\TourOperations\\HTOL Finance\\Finance Team\\MACS\\YE OCT-16\\05. March 2016\\1. MACS\\1. HTOL_MACs P&L BS Mar 16.xlsm" "1. P&L!R10C6"}/-1000) \# "£,0k"}
Fourth, press F9 to update the field.
Done.

 

[Scrappy666]

Macropod, i'm in awe.

I never thought I would get a response to this but i took a shot.
That is extremely detailed, worked like a charm and seriously impressive.

Thank you!
Daniel.