Dbl2IdeaStr

The function converts a double value into a valid string which can be used within an IDEA equation.

Compatibility

Available as of IDEA version 9.1.1

Syntax

DblI2deaStr(value As Double, decimal As String)

Parameters

value

Value which shall be transferred into a string.

decimal

Number of decimals which shall be used.

Remark

As a decimal separator the IDEA separator shall always be used. There are use cases where this separator is not identical to the separator specified in the regional settings.

Example

Option Explicit 

Sub Main() 
	on error goto erh 
	Dim cmds As Object 
	Dim d As Double 
	Dim s As String 

	Set cmds = SmartContext.MacroCommands.SimpleCommands 
	d = 1000.1 
	s = cmds.Dbl2IdeaStr(d, 2) 's = "1000.10" 
	Exit Sub 
erh: 
	'Error 
End Sub

Copy example