MI Label Format Number - Revision history

Anne.Kolega: /* Introduction */ added e.g.

2026-04-01T01:29:37Z

Introduction: added e.g.

← Older revision		Revision as of 11:29, 1 April 2026
Line 1:		Line 1:
	=Introduction=		=Introduction=
	To control the number of decimal places when creating labels for a number (float) field (eg. a Z or Elevation attribute), follow these steps.		To control the number of decimal places when creating labels for a number (float) field (e.g. a Z or Elevation attribute), follow these steps.
	=With miTools=		=With miTools=
	<ol>		<ol>

Emilie Nielsen at 01:42, 8 January 2026

2026-01-08T01:42:28Z

← Older revision		Revision as of 11:42, 8 January 2026
Line 35:		Line 35:
	Format$(0.054321, "#.##%") ' returns "5.43%"<br>		Format$(0.054321, "#.##%") ' returns "5.43%"<br>
	Format$(0.054321, "0.##\%") ' returns "0.05%" <br>		Format$(0.054321, "0.##\%") ' returns "0.05%" <br>


			{{Tips Navigation
			\|uplink=[[MapInfo_Tips\| Back to MapInfo Tips]]
			}}

Ari Craven at 03:39, 5 September 2011

2011-09-05T03:39:01Z

@@ Line 18: / Line 18: @@
 The attribute can be entered by using the Columns drop down list.  For the format string, use something like “0.00” making sure that you provide the quotes.  MapInfo uses the same (or very similar) formatting strings as Microsoft Excel does when formatting a Number cell.  Examples are “0.00” to display to two decimal places, “0.0” to display to one decimal place.  Examples from the MapInfo help are shown further below.  The line entered in the dialog below is:  Format$(Elevation,"0.00")
 [[File:12.1.6-2.png|frame|none]]
 </ol>

tuflow>Par at 03:35, 5 September 2011

2011-09-05T03:35:32Z

← Older revision		Revision as of 13:35, 5 September 2011
Line 1:		Line 1:
			=Introduction=
	To control the number of decimal places when creating labels for a number (float) field (eg. a Z or Elevation attribute), follow these steps.		To control the number of decimal places when creating labels for a number (float) field (eg. a Z or Elevation attribute), follow these steps.
			=With miTools=
		⚫	<ol>
			<li>Press the button</li>
			Describe how to change the format with the .ini file.
			Image here
			</ol>
			=Without miTools=
	<ol>		<ol>
	<li> Go to Layer Control, tick the label box for the layer you wish to label and press Label…. to display the dialog below. In the “Label with:” field, select Expression…		<li> Go to Layer Control, tick the label box for the layer you wish to label and press Label…. to display the dialog below. In the “Label with:” field, select Expression…
	</li>		</li>
⚫	<br>
	[[File:12.1.6.png\|frame\|none]]		[[File:12.1.6.png\|frame\|none]]
	<br>		<br>
Line 10:		Line 17:
	<br>		<br>
	The attribute can be entered by using the Columns drop down list. For the format string, use something like “0.00” making sure that you provide the quotes. MapInfo uses the same (or very similar) formatting strings as Microsoft Excel does when formatting a Number cell. Examples are “0.00” to display to two decimal places, “0.0” to display to one decimal place. Examples from the MapInfo help are shown further below. The line entered in the dialog below is: Format$(Elevation,"0.00")		The attribute can be entered by using the Columns drop down list. For the format string, use something like “0.00” making sure that you provide the quotes. MapInfo uses the same (or very similar) formatting strings as Microsoft Excel does when formatting a Number cell. Examples are “0.00” to display to two decimal places, “0.0” to display to one decimal place. Examples from the MapInfo help are shown further below. The line entered in the dialog below is: Format$(Elevation,"0.00")
	<br>
	<br>
	[[File:12.1.6-2.png\|frame\|none]]		[[File:12.1.6-2.png\|frame\|none]]

Ari Craven at 03:30, 5 September 2011

2011-09-05T03:30:03Z

← Older revision		Revision as of 13:30, 5 September 2011
Line 8:		Line 8:
	<li> The dialog below should now be displayed. For the expression, use the Format$() string function as shown below (this can be entered by using the Functions drop down list on the right of the dialog). The first argument is the attribute (Elevation in the example below), and the second is a format string.		<li> The dialog below should now be displayed. For the expression, use the Format$() string function as shown below (this can be entered by using the Functions drop down list on the right of the dialog). The first argument is the attribute (Elevation in the example below), and the second is a format string.
	</li>		</li>
			<br>
	The attribute can be entered by using the Columns drop down list. For the format string, use something like “0.00” making sure that you provide the quotes. MapInfo uses the same (or very similar) formatting strings as Microsoft Excel does when formatting a Number cell. Examples are “0.00” to display to two decimal places, “0.0” to display to one decimal place. Examples from the MapInfo help are shown further below. The line entered in the dialog below is: Format$(Elevation,"0.00")		The attribute can be entered by using the Columns drop down list. For the format string, use something like “0.00” making sure that you provide the quotes. MapInfo uses the same (or very similar) formatting strings as Microsoft Excel does when formatting a Number cell. Examples are “0.00” to display to two decimal places, “0.0” to display to one decimal place. Examples from the MapInfo help are shown further below. The line entered in the dialog below is: Format$(Elevation,"0.00")
			<br>
	<br>		<br>
	[[File:12.1.6-2.png\|frame\|none]]		[[File:12.1.6-2.png\|frame\|none]]

Ari Craven at 03:29, 5 September 2011

2011-09-05T03:29:28Z

← Older revision		Revision as of 13:29, 5 September 2011
Line 8:		Line 8:
	<li> The dialog below should now be displayed. For the expression, use the Format$() string function as shown below (this can be entered by using the Functions drop down list on the right of the dialog). The first argument is the attribute (Elevation in the example below), and the second is a format string.		<li> The dialog below should now be displayed. For the expression, use the Format$() string function as shown below (this can be entered by using the Functions drop down list on the right of the dialog). The first argument is the attribute (Elevation in the example below), and the second is a format string.
	</li>		</li>
	The attribute can be entered by using the Columns drop down list. For the format string, use something like “0.00” making sure that you provide the quotes. MapInfo uses the same (or very similar) formatting strings as Microsoft Excel does when formatting a Number cell. Examples are “0.00” to display to two decimal places, “0.0” to display to one decimal place. Examples from the MapInfo help are shown further below. The line entered in the dialog below is:		The attribute can be entered by using the Columns drop down list. For the format string, use something like “0.00” making sure that you provide the quotes. MapInfo uses the same (or very similar) formatting strings as Microsoft Excel does when formatting a Number cell. Examples are “0.00” to display to two decimal places, “0.0” to display to one decimal place. Examples from the MapInfo help are shown further below. The line entered in the dialog below is: Format$(Elevation,"0.00")
	<br>
	Format$(Elevation,"0.00")<br>
	<br>		<br>
	[[File:12.1.6-2.png\|frame\|none]]		[[File:12.1.6-2.png\|frame\|none]]

Ari Craven at 03:28, 5 September 2011

2011-09-05T03:28:57Z

← Older revision		Revision as of 13:28, 5 September 2011
Line 9:		Line 9:
	</li>		</li>
	The attribute can be entered by using the Columns drop down list. For the format string, use something like “0.00” making sure that you provide the quotes. MapInfo uses the same (or very similar) formatting strings as Microsoft Excel does when formatting a Number cell. Examples are “0.00” to display to two decimal places, “0.0” to display to one decimal place. Examples from the MapInfo help are shown further below. The line entered in the dialog below is:		The attribute can be entered by using the Columns drop down list. For the format string, use something like “0.00” making sure that you provide the quotes. MapInfo uses the same (or very similar) formatting strings as Microsoft Excel does when formatting a Number cell. Examples are “0.00” to display to two decimal places, “0.0” to display to one decimal place. Examples from the MapInfo help are shown further below. The line entered in the dialog below is:
	<br>
	<br>		<br>
	Format$(Elevation,"0.00")<br>		Format$(Elevation,"0.00")<br>

	<br>		<br>
	[[File:12.1.6-2.png\|frame\|none]]		[[File:12.1.6-2.png\|frame\|none]]

Ari Craven at 03:25, 5 September 2011

2011-09-05T03:25:53Z

← Older revision		Revision as of 13:25, 5 September 2011
Line 6:		Line 6:
	[[File:12.1.6.png\|frame\|none]]		[[File:12.1.6.png\|frame\|none]]
	<br>		<br>
	<li> The dialog below should now be displayed. For the expression, use the Format$() string function as shown below (this can be entered by using the Functions drop down list on the right of the dialog). The first argument is the attribute (Elevation in the example below), and the second is a format string. The attribute can be entered by using the Columns drop down list. For the format string, use something like “0.00” making sure that you provide the quotes. MapInfo uses the same (or very similar) formatting strings as Microsoft Excel does when formatting a Number cell. Examples are “0.00” to display to two decimal places, “0.0” to display to one decimal place. Examples from the MapInfo help are shown further below. The line entered in the dialog below is:		<li> The dialog below should now be displayed. For the expression, use the Format$() string function as shown below (this can be entered by using the Functions drop down list on the right of the dialog). The first argument is the attribute (Elevation in the example below), and the second is a format string.
		⚫	</li>
			The attribute can be entered by using the Columns drop down list. For the format string, use something like “0.00” making sure that you provide the quotes. MapInfo uses the same (or very similar) formatting strings as Microsoft Excel does when formatting a Number cell. Examples are “0.00” to display to two decimal places, “0.0” to display to one decimal place. Examples from the MapInfo help are shown further below. The line entered in the dialog below is:
	<br>		<br>
	<br>		<br>
	Format$(Elevation,"0.00")<br>		Format$(Elevation,"0.00")<br>

⚫	</li>
	<br>		<br>
	[[File:12.1.6-2.png\|frame\|none]]		[[File:12.1.6-2.png\|frame\|none]]

Ari Craven at 03:23, 5 September 2011

2011-09-05T03:23:40Z

← Older revision		Revision as of 13:23, 5 September 2011
Line 10:		Line 10:
	<br>		<br>
	Format$(Elevation,"0.00")<br>		Format$(Elevation,"0.00")<br>
⚫	[[File:12.1.6-2.png\|frame\|none]]
	</li>		</li>
			<br>
		⚫	[[File:12.1.6-2.png\|frame\|none]]

	</ol>		</ol>

Ari Craven at 03:12, 5 September 2011

2011-09-05T03:12:21Z

← Older revision		Revision as of 13:12, 5 September 2011
Line 10:		Line 10:
	<br>		<br>
	Format$(Elevation,"0.00")<br>		Format$(Elevation,"0.00")<br>
	[[File:12.1.6-2,png\|frame\|none]]		[[File:12.1.6-2.png\|frame\|none]]
	</li>		</li>
	</ol>		</ol>