View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ed from AZ Ed from AZ is offline
external usenet poster
 
Posts: 120
Default 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