You are here: All Help Topics > Accounting and Assurance > Calculations, Functions and Linkages > MKDEC function
-- Reference --

MKDEC Function

The MKDEC function converts any format to decimal.

  • String values should be placed in quotes "" within the brackets.
  • When passing numbers, use a period as the decimal separator.
  • For numeric strings, the decimal separator must be set in the Regional Settings.


  • MKDEC("3.99")

    Returns a value of 3.99 to the cell.

Note: Do not use the MKDEC function with the CVEXCEL function when returning numeric strings.

Related Topics