The CCur function in VBA is used to convert an expression into a Currency data type. It can take a maximum of 15 digits to the left of the decimal place and a maximum of 4 digits to the right of the decimal place.

Syntax

Parameter

Expression (required)– This parameter represents the expression that is converted to a Currency.

Return

This function returns a currency value ranging between -922,337,203,685,477.5808 and 922,337,203,685,477.5807.

Example 1

Output

$25.00

VBA CCur Function

Example 2

Output

($25.00)

Example 3

Output

$5,525.00

VBA CCur Function

Pin It on Pinterest

Share This