Remove Decimal Places From Currency Format

Question

User-620468895 posted

Does anoyone know how to remove the trailing zeros from a currency formated string:

for example in the showad.aspx.c there is  a line which show the price of an item using this code:

AdPriceLabel.Text = String.Format("{0:c}", ad.Price);

if the value on the database table is 5 then it is diaplyed on the web page as:

 $5.00

 All the numbers in my datbase are whole numbers (no decimal places).

Answer 1

User-1580617485 posted

Inspect the Current Number format System.Threading.Thread.CurrentThread.CurrentCulture.NumberFormat.CurrencyDecimalDigits; You can achieve the desired result as follows.

System.Globalization.NumberFormatInfo nfi = new System.Globalization.NumberFormatInfo();

nfi.CurrencyDecimalDigits = 0;

nfi.CurrencySymbol = "$";

AdPriceLabel.Text = String.Format(nfi,"{0:c}", ad.Price);

 

Hope it helped.

Answer 2

User-1580617485 posted
Let us know if not resolved. Thanks

Answer 3

User-620468895 posted
that worked great thanks.

Answer 4

User-620468895 posted
that worked great thanks. is

Answer 5

User-620468895 posted
that worked great thanks. is there any way to make

Answer 6

User-620468895 posted
that worked great thanks. is there any way to

Answer 7

User-620468895 posted
that worked great thanks. is there any way to make that a

Answer 8

User-620468895 posted
that worked great thanks. is there

Answer 9

User-620468895 posted
that worked great thanks. is there any way to make that

Answer 10

User-620468895 posted
that worked great thanks. is there any way

Answer 11

User-620468895 posted
that worked great thanks. is there any way to make that a global setting in say

Answer 12

User-620468895 posted
that worked great thanks. is there any way to make that a global setting in

Answer 13

User-620468895 posted
that worked great thanks. is there any way to make that a global setting in say the

Answer 14

User-620468895 posted
that worked great thanks. is there any way to make that a global setting

Answer 15

User-620468895 posted
that worked great thanks. is there any way to make that a global

Answer 16

User-620468895 posted
wow, i don;t know what happened there but it posted a bout ten times.

Answer 17

User-1580617485 posted

Yes we can. The section How to: Set the Culture and UI Culture for ASP.NET Web Page Globalization provides the overview.

And Update the thread status thanks.

Answer 18

User1272303263 posted

Inspect the Current Number format System.Threading.Thread.CurrentThread.CurrentCulture.NumberFormat.CurrencyDecimalDigits; You can achieve the desired result as follows.

System.Globalization.NumberFormatInfo nfi = new System.Globalization.NumberFormatInfo();

nfi.CurrencyDecimalDigits = 0;

nfi.CurrencySymbol = "$";

AdPriceLabel.Text = String.Format(nfi,"{0:c}", ad.Price);

 

Hope it helped.

 

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

Hello,

Can you tell me, where is this code located exactly. I need to make the changes as above, but i am unable to trace the location of the code.

I am unable to find the file that carries this code.

Help me please.

Thanks in advance.

Paggy4u

Answer 19

User-1580617485 posted

There is no file. The code is right there. Please explain what you are trying to achieve?

Thanks.

Answer 20

User1272303263 posted

There is no file. The code is right there. Please explain what you are trying to achieve?

Thanks.

 

Thats what i am trying to achieve, I acannot locate the code in this huge classified starterkit.

I just want to know, where is this code located. ( It must be inside some aspx or aspx.vb file )

I just want to know that file name.

Thanks

Answer 21

User-620468895 posted

copme on paggy, don't be lazy and use a text search tool, the more you help yourself the more you'll learn.

showad.aspx

remember "Help comes to those who help themselves"

Answer 22

User1272303263 posted
Hi,

I was more busy finding a better solution. ( More Active rather than being LAZY )

I have removed the decimals in many places. i shall be placing the codes tomorrow.

Thanks

Paggy4u

Answer 23

User1137530663 posted

Hi,
I've encountered the same problem but is unable to get the above mentioned solution to work. My code is as below:

Dim nfi As System.Globalization.NumberFormatInfo = New System.Globalization.NumberFormatInfo

nfi.CurrencyDecimalDigits = 2
nfi.CurrencySymbol = "$"

Dim myAmt As String = "300.440000000000"
Me.Label_Amount.Text = String.Format(nfi, "{0:c}", myAmt)

 

 The result is still same. The currency symbol wasn't even prefix to the string at all! Am I missing something here? Thanks in advance.
 

Answer 24

User-1580617485 posted
Me.Label_Amount.Text = String.Format(nfi, "{0:c}", Convert.ToDecimal(myAmt))

Answer 25

User1137530663 posted
I see. Thanks.

Answer 26

User1108651750 posted

If you use multiple cultures in your app, you might want to use the following to instantiate the NumberFormatInfo so that the current culture is used (instead of just constructing one with 'new'):

 System.Globalization.NumberFormatInfo nfi = (System.Globalization.NumberFormatInfo)System.Globalization.NumberFormatInfo.CurrentInfo.Clone();

 

Answer 27

User1593022345 posted

{0:c} default

{0:c0} for no decimal

{0:c3}for 3 decimal places and so on.

add 1,2,3 any number after c for that many decimal places

Answer 28

User-1096630142 posted

I would just like to point out to anyone else searching on this thread, that there is a better way of accomplishing this.

String.Format("0:C0") will work as well.  The 0 after the C specifices the number of decimal places.