Question

How to format decimal places in VB.NET

Answer 1

Imports System

Public Class Program
	Public Shared Sub Main()
        Console.WriteLine(String.Format("{0:0.00}", 1238.4567))
		
        Console.WriteLine(String.Format("{0:0.00}", 1238.5))
		
        Console.WriteLine(String.Format("{0:0.00}", 1238.0))
    End Sub
End Class





' run:
'
' 1238.46
' 1238.50
' 1238.00
'

 

70+ SQL courses for beginners and professionals

Answer 2

Imports System

Public Class Program
	Public Shared Sub Main()
        Console.WriteLine(String.Format("{0:0.##}", 1238.4567))
		
        Console.WriteLine(String.Format("{0:0.##}", 1238.5))
		
        Console.WriteLine(String.Format("{0:0.##}", 1238.0))
    End Sub
End Class






' run:
'
' 1238.46
' 1238.5
' 1238
'

 

70+ SQL courses for beginners and professionals

Answer 3

Imports System

Public Class Program
	Public Shared Sub Main()
        Console.WriteLine(String.Format("{0:00.0}", 1238.4567))
		
        Console.WriteLine(String.Format("{0:00.0}", 123.4567))
		
        Console.WriteLine(String.Format("{0:00.0}", 1247.5))
		
        Console.WriteLine(String.Format("{0:00.0}", 1247.0))
		
        Console.WriteLine(String.Format("{0:00.0}", 3.14159))
		
        Console.WriteLine(String.Format("{0:00.0}", -3.14159))
    End Sub
End Class







' run:
'
' 1238.5
' 123.5
' 1247.5
' 1247.0
' 03.1
' -03.1
'

 

70+ SQL courses for beginners and professionals

Answer 4

Imports System

Public Class Program
	Public Shared Sub Main()
        Console.WriteLine(String.Format("{0:0,0.0}", 1238.4567))
		
        Console.WriteLine(String.Format("{0:0,0.0}", 12390.4467))
		
        Console.WriteLine(String.Format("{0:0,0.0}", 123907.4567))
		
        Console.WriteLine(String.Format("{0:0,0.0}", 1247.4))
		
        Console.WriteLine(String.Format("{0:0,0.0}", 1247.0))
    End Sub
End Class








' run:
'
' 1,238.5
' 12,390.4
' 123,907.5
' 1,247.4
' 1,247.0
'

 

70+ SQL courses for beginners and professionals