Not getting ".0" in tenths in calculation?

[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

 

[Rick Rothstein \(MVP - VB\)]

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

 

[Ed from AZ]

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 -