Changing Number format in VBA message Box

[jumbo99]

I have a message box in VBA which displays the variable "cash". I am using the "currency" format as below:

cash = Format(cash, "currency")

The problem is that if the amount goes over £10000 it does not put a comma after the first zero (£10,000) to make it clearer to read. I have tried every combination of #,0 etc to make a custom format but it still does not
show a comma after the first zero.

Any ideas.

 

[jumbo99]

Further to this, it is something to do with displaying more than one variable within the message box. When I display the "cash" value on its own within the message box it displays correctly with a comma after the zero. I cannot understand why two "vbnewline" and three " &" would cause it to display wrong.

 

[Fluff]

Did you make the change I suggested?

 

[jumbo99]

Many thanks Fluff, you have stopped me banging my head on the desk. Regards.

 

[Fluff]

Glad we could help & thanks for the feedback.