Como dar formato numerico a 2 decimales a celda exel desde formulario VB.NET

Question

Estoy creando un formulario para crear una hoja de Exel, en VB.Net. Todo va bien, pero quiero formatear la celda en numerica tipo moneda con 2 decimales.

Cual seria la funsion

Gracias

Answer 1

Hi @gilberto ,

Suppose you are using the Microsoft.Office.Interop.Excel library to operate Excel.

You can refer to the following code to set the NumberFormat.

        Dim cell As Range = excelWorksheet.Range("A1")
        cell.Value = 1234.5678
        cell.NumberFormat = "$#,##0.00"

Best Regards.

Jiachen Li

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.