Format Numbers in TextBox 1

[navyguysrighthandman]

I need to make one textbox display in scientific notation and a couple others have only 2 decimal places. The data is being brought in from excel. Does anyone know how to do this? Thanks!

 

[Bowers74]

Where is the data being brought into?



If you can't be "The Best", be the best at what you can!!!

Never say Never!!!
Nothing is impossible!!!

 

[navyguysrighthandman]

The text boxes are in a user form created using Visual Basic. I have already formatted the cells in excel but the formatting is lost in the textbox.

 

[VBAva]

hey,
what format is the data in before it gets to the text box?

 

[VBAva]

Hello,

the formatting in the textbox depends onhow you take the values from the sheet.

if you use
TextBox2.Value = Range("Aa6&quot.Value
or
TextBox2.Value = Range("A6&quot
both of these will show the actual number, or magnitude in the box

but if you use
TextBox1.Value = Range("A6&quot.Text
the text box will show the number exactly as it appears in the sheet, and not change the formatting.

Hope it helps

 

[Bowers74]

When you populate the TextBoxes use the following to:

'Format in Scientific format
TextBox1 = Format(TextBox1.Value, "Scientific&quot

'Format with 2 decimals
TextBox2 = Format(TextBox2.Value, "#,##0.00&quot

I hope this helps!


If you can't be "The Best", be the best at what you can!!!

Never say Never!!!
Nothing is impossible!!!

 

[navyguysrighthandman]

Thanks guys. I finally got it to work! This info is probably applicable to a lot of people so I'm going to give it a star.