Is this what you are looking for?
Code:
Range("A1").NumberFormat = "##\,##\,##\,##0.00;[<-999999](##\,##\,##0.00);##,##0.00"