FormatNumber replace Decimal with Comma using SpreadsheetGear dll

Question

I want to apply Format Number to a Excel Cell from VB.net using SpreadsheetGear dll as below

This number 2,22,222.00 needs to convert to 2.22.222,00

My work:

worksheet.Range(NumberRange).NumberFormat = "[=0]0;###,###.00"

I am applying this format for English language, similar way I want number format to convert and display in the cell.

Sorry it may not be portugal but I want thousand seperator as "." and decimal seperator as "," using number format symbol something like "[=0]0;###,###.00" from vb.net — Ramesh, Oct 10 '14 at 11:50

score 0 · Answer 1 · edited Oct 10 '14 at 11:54

0

You can try this.

CultureInfo.GetCultureInfo("PT").NumberFormat

edited Oct 10 '14 at 11:54

Vivek S.

answered Oct 10 '14 at 08:24

Alex Blokha

I want thousand seperator as "." and decimal seperator as "," using number format symbol something like "[=0]0;###,###.00" from vb.net – Ramesh Oct 10 '14 at 11:57

1 Answers1