Format question

[OC]

What would be the best way to check for a decimal number coming in as, for
example, 99999.9999 and truncating it to 99999.99?

IOW, if it is 4 digits after the decimal, truncate it to 2.

[Erik Frey]

"OC" <nf*@nospam.com> wrote in message
news:%2****************@TK2MSFTNGP11.phx.gbl...

What would be the best way to check for a decimal number coming in as, for
example, 99999.9999 and truncating it to 99999.99?

IOW, if it is 4 digits after the decimal, truncate it to 2.

You could probably fiddle around with string formatting, but for most
decimal numbers, this should work fine:

decimal dec = 99999.9999M;
dec = Decimal.Truncate(dec * 100) / 100;
MessageBox.Show(dec.ToString());

Erik

[Sherif ElMetainy]

Hello

decimal d = 99999.9999M;
string s = d.ToString("0.00");

but this would format 1.1 as 1.10 and 4 as 4.00

Best regards
Sherif

"OC" <nf*@nospam.com> wrote in message
news:#6**************@TK2MSFTNGP11.phx.gbl...

What would be the best way to check for a decimal number coming in as, for
example, 99999.9999 and truncating it to 99999.99?

IOW, if it is 4 digits after the decimal, truncate it to 2.

[Erik Frey]

"Sherif ElMetainy" <el*************@wayout.net.NOSPAM> wrote in message
news:ey***************@TK2MSFTNGP11.phx.gbl...

Hello

decimal d = 99999.9999M;
string s = d.ToString("0.00");

but this would format 1.1 as 1.10 and 4 as 4.00

Best regards
Sherif

That doesn't truncate - it rounds. The result in string s is
"100000.00", not "99999.99".

Erik

[Cezary Nolewajka]

You could use regular expressions to analyze and get groups of digits before and after the "." sign and then appropriately truncate your decimal part.

--
Cezary Nolewajka
mailto:c.*********************@no-sp-am-eh-mail.com
remove all "no-sp-am-eh"s to reply
"OC" <nf*@nospam.com> wrote in message news:%2****************@TK2MSFTNGP11.phx.gbl...

What would be the best way to check for a decimal number coming in as, for
example, 99999.9999 and truncating it to 99999.99?

IOW, if it is 4 digits after the decimal, truncate it to 2.