I'm using access as my database and vb .net 2008.My problem is i change a field into 2 ecimal places and when i debug my program why my data in the datagridview not a 2 decimalExample : in access TotalCost = 200.00in vb form datagridview TotalCost = 200
View 1 RepliesWhat is the cleanest, most readable way to String.Format a decimal with the following criteria
start with a sign symbol (+ or -)
a fixed number of fraction digits
no decimal separator
right aligned
pre-padded with "0"'s
format number to hower many number on left of decimal and 1 decimal without rounding
View 2 RepliesI want to convert numbers from 0 to 15 like that
[Code]...
Problem is that when we convert 2 to binary number it gives only 10 in binary, but i want to convert 2 to 4 bit binary number 0010.
I am calling the function below from an Excel spreadsheet and the conversion from hex to decimal using the VAL function in the "manufacturer" variable below is coming back with a negative value. The VBA edition is 6.5.
Public Function decMEID(ByVal sKey As String) As String
Dim manufacturer As String
Dim serial As String
[code].....
im having trouble understanding this question for a homework assignment. I need to write the PSEUDOCODE for the following scenario, but i got no idea about how to convert a hexadecimal number to a decimal number..You are required to input a two digit hexadecimal number eg. 3f (digits can be entered separately) and calculate the equivalent decimal number. (note the decimal number will be between 0 and 255) . output the decimal number
View 1 RepliesTo allow a textbox to contain "15" or 15.5" as numbers nothing else...I figured that ^\d+$ works for numbers but can't get decimals to work also?
View 1 RepliesHow can I only add the decimal part of a number to another one?
example: if a number is A = 10.25
Then X = 30
Y = X + 0.25 (Here it added 0.25 which the decimal only NOT 10.25)
Another example, If X = 16.35, A = 102.001
Y = 16.351
I am attempting to take the decimal places of a given input, round it so there are only two decimal places, then change it to a whole number. So far I have been able to remove the integer part of the number, leaving only the decimal, but the other procedures are eluding me. Here's what I have so far: (VB 2008)
Private Function DecimalNumber(ByVal number As Double) As Double
Dim Input As Double
Dim SubtractNumber As Decimal
[Code]....
That code returns the decimal part of the input just fine, and I thought maybe multiplying it by 10 would work....but obviously you run into problems when there is more than one decimal place.
I have class representing a unit of measure with a Decimal as the numeric. Just to simplify things for this example, let's say I'm representing centimeters. I'd like to implement a ToString() method for this class. The thing is, if the numeric value is a whole number I'd like to just display the decimal as an integer. Otherwise, I'd like to keep it as a decimal. So, for example, 10.5D centimeters would display as "10.5cm", but 7.0D centimeters should display as "7cm". I'd like this to be fast and simple to read. I have a working solution, but it seems like there should be a better way.Here's a contrived example showing my first crack at it:
Public Property Units As String = "cm"
Public Property NumericValue As Decimal = 10.5D
Public Overrides Function ToString()
[code].....
How to convert a whole number into decimal..For example 70 to .70 because there are some price in my system that needed to be calculated by grams for example $5 per grams... I am saving the price in my database as an integer..
View 2 Repliesi am using that code i have one datagridview and datagridview cell 3 value is 7
Dim n As Integer
For a = 0 To DataGridView1.Rows.Count - 1
If DataGridView1.Rows(a).Cells(0).Value = True Then
n = DataGridView1.Rows(a).Cells(3).Value
[code]....
the above code answer is 4 but i want the answer like that 3.5
How do I check how many decimal places does a number have in VB.net?
For example: Inside a cicle I have an if statement and on that statement I want to check if a number has 4 decimal places (8.9659)
How can I get the number of the decimal place, example 1.30 then it should give 2, for 5.0101 should give 4. I'm now doing that:
[Code]...
I have a problem regarding the number and want the number become from this: RM 2 to be like this: RM 2.00 [code]...
View 3 RepliesHow to convert the textbox.text to a number with decimal points. Once the subroutine have been process, the numbers will be dispalyed on the textbox or label in a format with two decimal numbers.
View 2 RepliesI have a field in datatable .If 1000 is the value in it, i want to display it as 1000.00.Then if user changes to 1000.50 it should display as it is.Is there anyway to do this?
View 4 Repliescorrect syntax to format decimals. I want 2 decimal places even if the result is an even number i.e. I want 40 to show as 40.00 and 40.6666667 to show as 40.67.
View 8 RepliesI want to know how to convert a percentage rate such as 4.5% into a decimal number in your code editor in V 2008.For example, the user input is 4.5%. Is there any function available to convert is to 0.045?
View 4 Replieshow do you detect how many decimals a decimal number has
View 10 RepliesI have two forms. the first form saves a decimal number and could also retrieve it. the second form just retrieves the number from the database. on the first form, i successfully retrieved the number with the decimals included. but on the second form, the number retrieved is displayed as a rounded up whole number. i tried to copy the codes of the first form but it still displays the rounded up number.
View 11 RepliesI have an internal process that requires data in a very specific format. Nothing I can do about that. So in my VB.NET program I am trying to output a number with a terminating decimal and nothing after it. I tried
swOut.WriteLine("{0,10:###0.}", var)
But the output is a whole number
886
913
941
[Code].....
Way to find out the numbers after the decimal point of the double?All i need to do is to find out if the number ends in 0 like 1.0 or 10.0 or 323.0 ?
View 6 RepliesI am trying to think of a possible way to insert a colon and decimal point to a part of a number. I am making a Rubik's Cube timer, and I converted the times to milliseconds so I can calculate the average of 5 with that. I averaged the milliseconds, but now I need to convert that into minutes, seconds, and milliseconds. Does anyone have any idea on how I would go about this?
View 2 Repliesive done a bmi calculator bbut the end result has 4 or 5 decimal places when i only need one. how do i limit the number of decimal places
View 3 Replieswant to return decimal number but because of "UBound" its keep displaying as integer how can i display decimal numbers?Public Class frmPrintbooks
Private Sub frmPrintbooks_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
For x = 0.0 To UBound(Form1.printBookName)
lstPrintbooks.Items.Add(Form1.printBookName(x) & " " & String.Format("{0:C}", Form1.printBookPrice(x)))
Next x
End Sub
[Code]...
How do I enable a user to set the number of decimal places in my code?essentially I have multiple variables in my code ,different kinds of pressure for example and with each instance I declare the following;
txt_Alt_Press.Text = Strat_Press.ToString(Press_DP)
I then set Press_DP in a module, declared as a public variable,
Public Press_DP As String = ("F1")
So what I want to do is make the "F1" bit a variable in itself, so then the user can set the number of decimal places with a numeric up-down control.
how i can format a number to only show decimal places if needed?For instance...
string.format("{0:SomeFormat}", 26.9) = "26.9"
and...
string.format("{0:SomeFormat}", 26.0) = "26" 'Drop decimal for whole numbers
I'm trying to limit the number of decimal values to 3 in numbers such as .3125 but I also have numbers such as .5 which I need to leave as is.
how can I determine if a number is 4 decimal places and cut off the last number.. I don't want to round up either.. .3125 should be .312 not .313 and .5 should stay at .5 and not .500.
I have got a decimal variable however i only want it to be to two decimal places. How can i set this?
View 4 Replies