I am not sure if you mean Format the values within the cell or msgbox.

Within the msgbox Statement you can use

FormatNumber(Range("F62").Value)
FormatCurrency(Range("F63").Value,2)

Msg = "Are you sure you want to delete Quantities?" & vbCr & vbCr _
& "No of Items:" & vbTab & Range("f61").Value & vbCr _
& "Tonnes:" & vbTab & vbTab & FormatNumber(Range("F62").Value) & vbC
_
& "Price:" & vbTab & vbTab & "$" & FormatCurrency(Range("F63").Value,2
" & vbCr

--
drawling
-----------------------------------------------------------------------
drawlings's Profile: http://www.excelforum.com/member.php...fo&userid=3662
View this thread: http://www.excelforum.com/showthread.php?threadid=57210