Formatting text box numbers (1 Viewer)

P

PaulSpell

Registered User.
Local time
Today, 13:53
Joined
Apr 19, 2002
Messages
201
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:
S

scottfarcus

Registered User.
Local time
Today, 13:53
Joined
Oct 15, 2001
Messages
182
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"
 
You must log in or register to reply here.

Similar threads

AOB
Solved Format textbox with special case for "1"
Replies
10
Views
624
cheekybuddha
cheekybuddha
A
Solved Two Combo Boxs for Name & Number
Replies
4
Views
362
accessonly11
A
A
Solved Creating an 'overflow' text box
Replies
2
Views
299
alikona
A
E
Solved Txt box on Form to add data
2
Replies
26
Views
715
Emma35
E
B
Using date from a text box in a where condition
Replies
6
Views
358
Pat Hartman
P

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Top Bottom