truncating a decimal to 2 decimal places??

[GaryB]

I have a database field that is the product of a multiply in a sql statement
and it sometimes has 5 or more decimal places. I want to truncate beyond
the 2nd decimal place(###.##). I figured a Ctype to a decimal value would
do that but the four decimal places remain. I found a truncate function but
it only truncates to whole numbers. how can I do the truncation?
Thanks,
G

[Just Me]

There are other ways, but you could multiply by 100, truncate, then divide
by 100
"GaryB" <[e-mail] m> wrote in message
news:OW******** ******@TK2MSFTN GP15.phx.gbl...

I have a database field that is the product of a multiply in a sql
statement
and it sometimes has 5 or more decimal places. I want to truncate beyond
the 2nd decimal place(###.##). I figured a Ctype to a decimal value would
do that but the four decimal places remain. I found a truncate function
but
it only truncates to whole numbers. how can I do the truncation?
Thanks,
G

[Herfried K. Wagner [MVP]]

* "GaryB" <[e-mail] m> scripsit:

I have a database field that is the product of a multiply in a sql statement
and it sometimes has 5 or more decimal places. I want to truncate beyond
the 2nd decimal place(###.##). I figured a Ctype to a decimal value would
do that but the four decimal places remain. I found a truncate function but
it only truncates to whole numbers. how can I do the truncation?

Take a look at 'Math.Round', 'Math.Floor', and 'Math.Ceiling'.

--
M S Herfried K. Wagner
M V P <URL:http://dotnet.mvps.org/>
V B <URL:http://dotnet.mvps.org/dotnet/faqs/>

[Lucas Tam]

" Just Me" <ne********@a-znet.com> wrote in
news:O7******** ******@TK2MSFTN GP12.phx.gbl:

There are other ways, but you could multiply by 100, truncate, then
divide by 100

Just use Math.round.

--
Lucas Tam (RE********@rog ers.com)
Please delete "REMOVE" from the e-mail address when replying.
http://members.ebay.com/aboutme/coolspot18/

[Ken Tucker [MVP]]

Hi,

Take a look at the numberformatinf o class.
Dim decTest As Decimal = CDec(5.0001)

Dim niDec As New System.Globaliz ation.NumberFor matInfo

niDec.NumberDec imalDigits = 4

Debug.WriteLine (decTest.ToStri ng(niDec))

Ken

-----------------------

"GaryB" <[e-mail] m> wrote in message
news:OW******** ******@TK2MSFTN GP15.phx.gbl...
I have a database field that is the product of a multiply in a sql statement
and it sometimes has 5 or more decimal places. I want to truncate beyond
the 2nd decimal place(###.##). I figured a Ctype to a decimal value would
do that but the four decimal places remain. I found a truncate function but
it only truncates to whole numbers. how can I do the truncation?
Thanks,
G

[Ken Tucker [MVP]]

Hi,

Sorry bad example.

Dim decTest As Decimal = CDec(5.0001)

Dim niDec As New System.Globaliz ation.NumberFor matInfo

niDec.NumberDec imalDigits = 2

Debug.WriteLine (decTest.ToStri ng("f", niDec))

Ken

----------------

"Ken Tucker [MVP]" <vb***@bellsout h.net> wrote in message
news:eF******** ******@TK2MSFTN GP12.phx.gbl...
Hi,

Take a look at the numberformatinf o class.
Dim decTest As Decimal = CDec(5.0001)

Dim niDec As New System.Globaliz ation.NumberFor matInfo

niDec.NumberDec imalDigits = 4

Debug.WriteLine (decTest.ToStri ng(niDec))

Ken

-----------------------

"GaryB" <[e-mail] m> wrote in message
news:OW******** ******@TK2MSFTN GP15.phx.gbl...
I have a database field that is the product of a multiply in a sql statement
and it sometimes has 5 or more decimal places. I want to truncate beyond
the 2nd decimal place(###.##). I figured a Ctype to a decimal value would
do that but the four decimal places remain. I found a truncate function but
it only truncates to whole numbers. how can I do the truncation?
Thanks,
G