the following code has illegal function error when i tried 1,501,800.00
could you help me what is the error in it?


MyScreen.Area(11,14,11,33).Value = Format(aSheet.Range("K" & i).Value,"* ##,##0.00;* #,##0.00;(@)" )