Format Number in Message Box

[nigelk]

Hi all

I have the following:

MsgBox "you have a charge of " & Cel.Offset(0, 1).Value

It's coming up as "You have a charge of 2"

but I would like it to read
"You have a charge of £2.00"

(It's formatted ok on the sheet)

can anyone help?

Thanks,Nigel

 

[Colin Legg]

Hi Nigel,

Try this:

 MsgBox "you have a charge of " & Format$(CStr(cel.Offset(0, 1).Value2), "£#,##0.00")

 

[Marcelo Branco]

Or maybe

MsgBox "you have a charge of " & Format(Cel.Offset(0, 1).Value, "Currency")

M.

 

[nigelk]

Works great.

Thank you Colin.