| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
| HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
| How can I use the "TODAY ()" Function in an "IF/THEN" calculation | Excel Worksheet Functions | |||
Linear Mode
