how to covert number to indian format

example

i need like
1234567.45 = 12,34,567.45

123456.00 = 1,23,456.00

re: how to covert number to indian format

try to sue FORMAT function.

re: how to covert number to indian format

you can use FORMATNUMBER Function as well.

re: how to covert number to indian format

hi
use following code to convert numbers in to indian format

Option Explicit

Private Function MyFormat(ByVal TNum As String) As String
Dim TStr As String
Dim OStr As String
Dim TempStr As String
'
TNum = Replace(TNum, ",", "")
'
OStr = Format(TNum, "0.00")
TStr = Right(OStr, 6)
If Len(OStr) <= 6 Then
MyFormat = TStr
Else
OStr = Left(OStr, Len(OStr) - 6)
Do
TempStr = Right(OStr, 2)
TStr = TempStr & "," & TStr
OStr = Left(OStr, Len(OStr) - Len(TempStr))
Loop Until Trim(OStr) = ""
MyFormat = TStr
End If
End Function

Private Sub Form_Load()
MsgBox MyFormat("121123456")
End
End Sub


regards
manpreet singh dhillon hoshiarpur