You are here: 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.
Syntax
MKDEC(expression)
-
Example
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.