Suppress the 0 in a form

dantb · Mar 30th, 2002, 08:05 PM

Hi all, I was wondering if there was anyway of not haveing the ( 0 ) on a decimal number. If you type .125 in on a form the next time I view the form it has 0.125, anyway of removing the 0 ? thx Dan

Dave Hawley · Mar 30th, 2002, 08:09 PM

Hi dantb

You haven't said what "the form" is, a Worksheet cell, Textbox, ComboBox etc

Anyway you can simply use format like

#.0000

dantb · Mar 30th, 2002, 08:12 PM

Hi Dave, sorry about that, It is a vba Userform and I save the data that is entered for future viewing. Would #.0000 be all I nead in this vba code ?

dantb · Mar 30th, 2002, 08:17 PM

This is the code I have in the Text box on the form. Would you enter that in the Code ?

Private Sub TextBox1_AfterUpdate()
Sheets("BUY - SELL").Range("C8").Value = TextBox1.Text
End Sub

Dave Hawley · Mar 30th, 2002, 08:19 PM

Hi dantb

If you are saving this to a Worksheet for later viewing then some code like:

Range("A1").NumberFormat = "#.0000"

Should work

If you are going to need this same format in a TextBox you can use something like:

Dim strNum as string
strNum =format(range("A1"),"#.0000"

dantb · Mar 30th, 2002, 08:24 PM

Ok Dave thanks again for you help. Just couldnt see how to do it. Thanks again have a good evening. Dan

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 30th, 2002, 08:05 PM	#1
dantb Board Regular Join Date: Mar 2002 Location: Arkansas Posts: 358	Hi all, I was wondering if there was anyway of not haveing the ( 0 ) on a decimal number. If you type .125 in on a form the next time I view the form it has 0.125, anyway of removing the 0 ? thx Dan

Mar 30th, 2002, 08:09 PM	#2
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Hi dantb You haven't said what "the form" is, a Worksheet cell, Textbox, ComboBox etc Anyway you can simply use format like #.0000

Mar 30th, 2002, 08:12 PM	#3
dantb Board Regular Join Date: Mar 2002 Location: Arkansas Posts: 358	Hi Dave, sorry about that, It is a vba Userform and I save the data that is entered for future viewing. Would #.0000 be all I nead in this vba code ?

Mar 30th, 2002, 08:17 PM	#4
dantb Board Regular Join Date: Mar 2002 Location: Arkansas Posts: 358	This is the code I have in the Text box on the form. Would you enter that in the Code ? Private Sub TextBox1_AfterUpdate() Sheets("BUY - SELL").Range("C8").Value = TextBox1.Text End Sub

Mar 30th, 2002, 08:19 PM	#5
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Hi dantb If you are saving this to a Worksheet for later viewing then some code like: Range("A1").NumberFormat = "#.0000" Should work If you are going to need this same format in a TextBox you can use something like: Dim strNum as string strNum =format(range("A1"),"#.0000"

Mar 30th, 2002, 08:24 PM	#6
dantb Board Regular Join Date: Mar 2002 Location: Arkansas Posts: 358	Ok Dave thanks again for you help. Just couldnt see how to do it. Thanks again have a good evening. Dan