P PaulSpell Registered User. Local time Today, 00:05 Joined Apr 19, 2002 Messages 201 Nov 18, 2002 #1 I need help formatting text box numbers! Does anyone know how to format numbers in a text box to show in millions? For example 3,444,222 would show as 3.4. Last edited: Nov 18, 2002
I need help formatting text box numbers! Does anyone know how to format numbers in a text box to show in millions? For example 3,444,222 would show as 3.4.
S scottfarcus Registered User. Local time Today, 00:05 Joined Oct 15, 2001 Messages 182 Nov 18, 2002 #2 Why not divide the given number by 1 million and then add some text to it. If txtNumber holds 2500000. The following code will return 2.5 Million in a text box called txtMillions. txtMillions = txtNumber / 1000000 & " Million"
Why not divide the given number by 1 million and then add some text to it. If txtNumber holds 2500000. The following code will return 2.5 Million in a text box called txtMillions. txtMillions = txtNumber / 1000000 & " Million"
