Not getting ".0" in tenths in calculation?
 

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

Not getting ".0" in tenths in calculation?
 

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" wrote in message
...
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

Not getting ".0" in tenths in calculation?
 

Thanks, Rick. The String variable worked.

Ed


On Jun 28, 12:09*pm, "Rick Rothstein \(MVP - VB\)"
wrote:
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" wrote in ...



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- Hide quoted text -

- Show quoted text -