text box 1000's Separators

[sam99]

Hi,
I have this code I just want to put 1000’s spectators to it how to d
that?

TextBox138.Value = Format(CDbl(TextBox135.Value)
CDbl(TextBox86.Value), "0.0000")


Than

 

[Claus Busch]

Hi Sam,

Am Sat, 21 Jul 2012 09:39:40 +0000 schrieb sam99:

TextBox138.Value = Format(CDbl(TextBox135.Value) /
CDbl(TextBox86.Value), "0.0000")

try:
With Sheets("Sheet1")
.TextBox138 = Format(CDbl(.TextBox135) / CDbl(.TextBox86), _
"0,00#.00")
End With


Regards
Claus Busch