Formatting numbers is not working

Question

I have this line, where I need to format a field. I did several ways and nothing:

lista.ForEach(e => e.Total = string.Format("{0:N}", float.Parse(e.Total)));

and so

lista.ForEach(e => e.Total = string.Format("{0:0.00}", float.Parse(e.Total)));

and more like this

lista.ForEach(e => e.Total = string.Format("{0:0,0.00}", float.Parse(e.Total)));

So it comes from the bank: 205.728 and the way out should be this: 205.73 and it’s getting like this: 205.728,00

The complete method

public List<ItensLibDTO> getItensLib(int id)
        {
            var lista = contexto.ItensLibs
                .Where(itens => itens.IdOrcamento == id)
                .Select(item => new ItensLibDTO
                {
                    Produto = item.Produto,
                    Qtde = item.Qtde.ToString(),
                    Unitario = item.Unitario.ToString(),
                    Custo = item.Custo.ToString(),
                    CustoDiario = item.CustoDiario.ToString(),
                    UltCondicao = item.UltCondicao.ToString(),
                    Total = item.Total.ToString()
                }).ToList();

            lista.ForEach(e => e.UltCondicao = new DateTime(1800, 12, 28).AddDays(float.Parse(e.UltCondicao)).ToString("dd/MM/yyyy"));
            lista.ForEach(e => e.Total = string.Format("{0:N}", float.Parse(e.Total)));

            return lista;
        }

Answer 1

To do this, you can join the class CultureInfo with the method ToString:

lista.ForEach(e => e.Total = float.Parse(e.Total).ToString("0.00").Replace(".", ","));

Don’t forget to add the use of the namespace where the Cultureinfo class is located:

using System.Globalization;

Explanation:

new CultureInfo("pt-BR"): Format the text according to the Brazilian standard, ie with comma in the numbers that have decimal places.

"0.00": Indicates that the text should have only 2 decimal places.

Answer 2

Just for the record, what you’re doing is a huge mess, and based on that, you might say your problems aren’t going to end here. The correct thing should be to solve the problem at the beginning and start doing everything correctly.

Given the legal warning, let’s solve it. The problem here is that the number is in American format, from there begins the mess with crops.

What you need to do is convert the number to double using the original format and then convert to string again, this time using the format you want in the presentation.

string.Format(new CultureInfo("pt-BR"), "{0:N}", 
              double.Parse("250.728", new CultureInfo("en").NumberFormat));