CCur Function

αž”αž˜αŸ’αž›αŸ‚αž„β€‹αž€αž“αŸ’αžŸαŸ„αž˜β€‹αžαŸ’αžŸαŸ‚β€‹αž’αž€αŸ’αžŸαžš αž¬β€‹αž€αž“αŸ’αžŸαŸ„αž˜β€‹αž›αŸαžβ€‹αž‘αŸ…β€‹αž‡αžΆβ€‹αž€αž“αŸ’αžŸαŸ„αž˜β€‹αžšαžΌαž”αž·αž™αž”αŸαžŽαŸ’αžŽΒ αŸ” αž€αžΆαžšβ€‹αž€αŸ†αžŽαžαŸ‹β€‹αž˜αžΌαž›αžŠαŸ’αž‹αžΆαž“β€‹αžαŸ’αžšαžΌαžœβ€‹αž”αžΆαž“β€‹αž”αŸ’αžšαžΎβ€‹αžŸαž˜αŸ’αžšαžΆαž”αŸ‹β€‹αžŸαž‰αŸ’αž‰αžΆβ€‹αž€αŸ’αž”αŸ€αžŸ αž“αž·αž„β€‹αžŸαž‰αŸ’αž‰αžΆβ€‹αžšαžΌαž”αž·αž™αž”αŸαžŽαŸ’αžŽΒ αŸ”

Syntax:


CCur(Expression As Variant) As Currency

Return value:

αžšαžΌαž”αž·αž™αž”αŸαžŽαŸ’αžŽ

Parameters:

Expression: Any string or a numeric expression that you want to convert to a number.
CCur(EMPTY) returns 0.

Error codes:

5 αž€αžΆαžšβ€‹αž αŸ…β€‹αž”αŸ‚αž”αž”αž‘β€‹αž˜αž·αž“β€‹αžαŸ’αžšαžΉαž˜αžαŸ’αžšαžΌαžœ

6 αž›αžΎαžŸβ€‹αž…αŸ†αžŽαž»αŸ‡

Example:


  Sub CCur_example
      Print CCur( expression := 145.279 * "654" )
      Print CCur( -258.0421E+02 )
  End Sub

Please support us!