Home |
Search |
Today's Posts |
#1
|
|||
|
|||
text box 1000's Separators
Hi,
I have this code I just want to put 1000’s spectators to it how to do that? TextBox138.Value = Format(CDbl(TextBox135.Value) / CDbl(TextBox86.Value), "0.0000") Thanx |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
text box 1000's Separators
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 -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text data with irregular data separators | Excel Discussion (Misc queries) | |||
Rounding of 1000's | Excel Programming | |||
Rounding of 1000's | Excel Programming | |||
my numbers go from 99 and then skip to 1000's? | Excel Discussion (Misc queries) | |||
Formatting in 1000's | New Users to Excel |