Excel: CCur Function (VBA only)

In Excel, the CCur function converts a value to currency.

The syntax for the CCur function is:

CCur( expression )

Applies To:

• Excel 2007, Excel 2003, Excel XP, Excel 2000

VBA Code

The CCur function can only be used in VBA code. For example:

Dim LValue As Double
Dim LCurValue As Currency

LValue = 123.4567812
LCurValue = CCur(LValue)

In this example, the CCur function would return the value 123.4568. The variable called LCurValue would now contain 123.4568.