I am trying to return a value to a msgbox, but instead of just the
actual value, I want the number to be formatted as fixed (i.e. using
"," as thousand seperator and only 2 decimal places).

MsgBox("The final valuation is " & Format(getNAP, "##,##0.00"))

HTH,
Merjet