Formatting returned values within a text string in VB

[DonkeyOte]

I am sure someone has probably explained this before but I have never been able to do the following.

I am running a spreadsheet that analyses actual versus budget positions in real time, part of this solution are automatic warning flag emails that get sent to various departments as and when adverse variances above 10% of budget arise. This is all fine and is coded etc... the problem I have is that when there's an adverse variance the VB creates a text string for the email along thses lines:

Nominal Code - Description of Code - Amount of Variance - "overspend" - in Q# (variable)

The problem is the Amount of Variance as I can not work out how to ensure that this values is returned in the format of #,##0.00

Anyone know how I can amend the below code to have this effect:

Range("P" & CROW) = Range("A" & CROW) & " - " & Range("B" & CROW) & " - " & -NCODE & " Overspend in Q" & Range("N1")

where -NCODE is equivalent to the value.

Thanks
Luke

I help you now you help me?

 

[Mudface]

Would .... & Format(-NCODE,"#,##0.00") & ...., work?

 

[dk]

Hello,

Use Format(YourVariable,"#,##0.00")

Is that what you mean?

 

[DonkeyOte]

Legends!

Thanks a lot...can't believe it was that simple - what a dunce!