Not getting ".0" in tenths in calculation?

  • Thread starter Thread starter Ed from AZ
  • Start date Start date
E

Ed from AZ

In Xl2007, I am making calculation to display in a test box. All
variables are Dim'd as Single. My code is:
trk1 = Format(VehKM - trkKM, "#####0.0")
But if the calcualtion leads to a whole number, when trk1 is displayed
in the MsgBox, it will not display the ".0" in the tenths place.

Can I change my variable type or Format parameters to get this zero
displayed?

Ed
 
Numerical values (such as Singles) have no format, they are just numbers...
1.23 is the same as 01.23 which is the same as 1.2300, and so on. Either
store the returned value from the Format function in a String variable and
send that to the MsgBox function; or send your Format statement to the
MsgBox function as its 1st argument....

MsgBox Format(VehKM - trkKM, "#####0.0")

Rick
 
Thanks, Rick. The String variable worked.

Ed


Numerical values (such as Singles) have no format, they are just numbers....
1.23 is the same as 01.23 which is the same as 1.2300, and so on. Either
store the returned value from the Format function in a String variable and
send that to the MsgBox function; or send your Format statement to the
MsgBox function as its 1st argument....

MsgBox Format(VehKM - trkKM, "#####0.0")

Rick







- Show quoted text -
Click to expand...
 
Back
Top