I need to change my output to 2 decimals even if input hass no decimals.

[ErinAline]

I am wanting to have a userform which brings in my information from the user and then outputs it to a spread sheet but I can't figure out how to get it to output in 2 decimal places if the user does not put in the value with any decimal places. I want it to always output to 2 decimals regardless of the users input significant figures. I've tried using NumberFormat but that hasn't gotten me anywhere



Cells(flightrow, 4) = "SECTIONAL FLIGHT, " & handcombo.Text & " , Ø" & FlightIDTextBox.NumberFormat = "0.00" & quote & " ID X Ø" & FlightODTextBox.Value & quote & "OD X " & FlightPitchTextBox.Value & quote & " PITCH"

Any help is greatly appreciated!

 

[James006]

Hi,
You could test following
Replace
& FlightIDTextBox.NumberFormat = "0.00"
by
& Format(FlightIDTextBox ,"#,##0.00")

Hope this will help