Hello every one,
i need to write a code to be as a private sub for a sheets, to have only two decimal numbers if the number has more than two decimal numbers not all numbers
iam using the following formula:
Sub bbbb()
Range("A18:C30").NumberFormat = "0.00"
Range("D3:D14").NumberFormat = "0.00"
End Sub
the problem its converted even the single number which was without decimel ex (25.00) i need it to be as its (25)
i need the result to be for the only if there is decimal number and the code to work automatic in the sheet like private sub
thanks for your support,
Bookmarks