• ABS Function
• AVERAGE Function
• CGROUP Function
• CGROUPT Function
• COLCOUNT Function
• COUNTIF function
• EXP Function
• FV Function
• LOG Function
• Mathematical and Financial Functions
• MAX Function
• MEDIAN Function
• MIN Function
• MKDEC Function
• MKINT Function
• MOD Function
• POS Function
• PV Function
• R Function
• RATIO Function
• RC Function
• RCNV Function
• RCR Function
• RCTOTAL Function
• ROUND Function
• ROWCOUNT Function
• RR Function
• RRTOTAL Function
• STDDEV Function
• SUM Function
• TOTAL Function

MKDEC Function

The MKDEC function converts any format to decimal.

• All string values should be placed in quotes "" within the brackets.
• Numbers passed must have the period as the decimal separator.
• For numeric strings the decimal separator must be set in the regional setting.

Syntax

MKDEC(expression)

Example

MKDEC("3.99")

Returns a value of 3.99 to the cell.

Related Topics

• Mathematical and Financial Functions