When using the CCur function: it doesn't matter how many digits a number has, it will always write only 2 digits into the cell. (In immediate window it would print 4 digits)
What can be the cause? Thank you very much
What can be the cause? Thank you very much
VBA Code:
Sub test()
Cells(1, 1).Value = CCur(50.5678956789) '50,57
End Sub