numbr with 3 decimal

Topic

New Reply

I get a part of string from a loop in text file with:
IMPORTO_OPERAZIONE = Format(Trim(Mid(inString, 88, 24) * 1), “#,##0.000”)
i have dimensioned IMPORTO_OPERAZIONE as double but the code return:
IMPORTO_OPERAZIONE =2692
i want to have IMPORTO_OPERAZIONE = 2.692,600
how to?

Reply | Quote

Replies

Sal,

I don’t have the European settings but from a quick look at your format string you may want to reverse the
comma & period to “#.##0,000”.

RG

May the Forces of good computing be with you!

RG

PowerShell & VBA Rule!
Computer Specs

Reply | Quote