• Mathematical and Financial Functions
  • 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