Navigation:  Menu Commands > Options Menu >

Number Format command (Options menu)

JR   Viewer

Print this Topic Previous pageReturn to chapter overviewNext page

Shortcut:

Right-click on numbers along any axis to select the number format for that axis.

Displays a dialog box that allows you to specify the appearance of numbers on the axes of the plot.

The following table shows some examples using the available number formats.

 

With this format

This number

Is displayed as

Default

-1.5

-1.5

 

0.

0.

 

1.5

1.5

None

any

nothing

Scientific

-1.5

-1.5E+0

 

0.

0E+0

 

1.5

1.5E+0

Powers of 10

150

 

0

0

 

0.015

Engineering

 

identical to Powers of 10, but all exponents are multiples of 3

Percent

1.5

150%

Currency 1

-1.5

($1.50)

see below

0.

$0.00

 

1.5

$1.50

Currency 2

-1.5

($2)

see below

0.

$0

 

1.5

$2

Time of day (hours)

1

*01:00:00 AM

 

1.5

*01:30:00 AM

 

13

*01:00:00 PM
or
13:00:00

Time of day (fractional days)

0.04166667 (1/24)

*01:00:00 AM

 

0.25

*06:00:00 AM

 

0.5

*12:00:00 PM

Calendar date

1

*1/1/1900

 

35242

*6/26/1996

Date and Time

35242

*6/26/1996 12:00:00 AM

 

35242. 5210069

*6/26/1996 12:30:15 PM

Day of the Week

1

Sun

 

2

Mon

 

8

Sun

Month

1

Jan

 

12

Dec

Elapsed time

-1.5

-1:30:00

 

0

0

 

1.5

1:30:00

Fractions

0.4

 

1.5

Fractions, no reduction
see below

0.4

Pi Multiples

0.785398

0.25π

 

4.71239

1.5π

Pi Fractions

0.785398

π/4

 

4.71239

3π/2

Degrees, Minutes

35.505556

35° 30.3'

Degrees, Minutes, Seconds

35.505556

35° 30' 20"

Hexadecimal

5346.24

0x14E2

* dependent on Date Format and/or Time Format settings

Axis

The X2 and Y2 axis entries (XY plots only) correspond to the secondary axes established by the Multiple Axes menu command. These selections are disabled if the corresponding axis has not been enabled. The Orientation settings are disabled for these entries and are forced to the orientation setting for the corresponding primary axis.

Format

Default format

Numbers with absolute values smaller than 0.00001 or larger than or equal to 10,000,000 are displayed in scientific notation with up to 5 significant figures. Trailing zeros are not displayed.

None

This format is primarily useful for creating blank graph paper. See the How do I? topic for more information.

Fractions

DPlot will pick the denominator from 2,3,4,5,6,8,10,12,15,16,20,24,25,30,32,40,50,60,64 that gives the smallest error. Fractions smaller than 1/128 are truncated. The Fraction format will reduce the fraction to its lowest terms, e.g. 3/60 becomes 1/20. Fractions, no reduction is identical other than that reduction: if the tick mark interval on an axis is 1/60 and a tick mark is at 3/60, it will be displayed as 3/60 rather than 1/20.

Currency

DPlot uses the currency format set with Control Panel's Regional Settings applet.

Time of day

For "Time of day (hours)", amplitudes should be in hours. Note that this differs from "Date and Time" and "Time of day (fractional days)" formats, in which time values are fractions of days. The time scale wraps around every 24 hours, with 0.0 equal to midnight (-1.0 = 23.0 = 47.0 = 11:00 PM, etc.) By default, DPlot uses the time format set with Control Panels International (or Regional Settings) applet. You can control how the time is formatted by entering a format string in the Time Format box.

Time format notation:
h = hour, m=minute, s=second, t=AM or PM (ignored for 24 hour clock)
h = 12 hour clock, H = 24 hour clock
hh or HH = leading zero on hour
h or H = no leading zero on hour
A .0 suffix will add tenths of seconds, .00 will add hundredths of seconds, etc. You can display time increments as small as microseconds with '.000000'. A seventh or subsequent 0 will be displayed but is ignored for formatting purposes.

Calendar date

DPlot converts the input Excel serial number to a calendar date. By default, DPlot uses the Short Date format specified in Control Panels International (or Regional Settings) applet for formatting the date. You can control how the date is formatted by entering a format string in the Date Format box. Use the letters in the following table to change the date style. As you type, the current date formatted using this style is shown below the style box.

To display

Use

Numbers with no leading zeros for single-digit days, years, or months.

Lowercase d or y, or uppercase M

Numbers with leading zeros for single-digit days, years, or months.

Lowercase dd or yy, or uppercase MM

Three-letter abbreviations for the day of the week or month.

Lowercase ddd or uppercase MMM

The full name of the day of the week, year, or month

Lowercase dddd or yyyy, or uppercase MMMM

The day of the year (Jan 1=1, Dec 31=365 or 366)

Lowercase n

 

Date and Time

Identical to Calendar date, with the exception that Calendar Date will sometimes include the time depending on the spacing between data values and the context, while Date and Time will always show the time in addition to the date, dependent on the Time format string. If you want to show only the time using this format, use <none> for the date format string.

Hexadecimal

Displays numbers in signed hexadecimal notation, dependent on the Size and Prefix settings under Hexadecimal Parameters. Fractional values are truncated. Numbers outside the range -0x80000000 to 0x7FFFFFFF (-2,147,483,648 to 2,147,483,647) are displayed using the default numerical format. The Size parameter will be ignored for amplitudes greater than the maximum value for that size. For example, if you select 1 Byte and a value is outside the range -128 to 127, 2 Byte will be forced on.

Degrees, Minutes and Degrees, Minutes, Seconds

The Use N/S/E/W suffix setting is only applicable to these formats. This setting is only used for numbers displayed along the X or Y coordinate axes for linear scales or Mercator projections. (It is not used, for example, in dialog boxes, the status bar, popup windows displaying coordinate values, or any other scale type.) If checked, the absolute values will be displayed along with the appropriate suffix (N or E for positive values, S or W for negative values).

Use 1000 Separator (,)

Check this box to display the thousand's separator character before every 3rd digit in the whole number portion of a value. The separator character is set by Control Panel's Regional Settings applet.

Decimal places

If Fixed number is checked, then the corresponding number of figures (including trailing 0's) are displayed after the decimal point. This option is only used for the default number format and for percentages, and is ignored for absolute values less than 0.00001 or larger than or equal to 10,000,000. Please note that this option does not enforce settings that make sense: 0.0001 will be displayed as 0.000 if 3 digits are selected, for example.

Orientation

Allows you to control the orientation of the numbers along each axis (default is horizontal). This option is ignored for polar plots, triangle plots, and 3D plots, and for secondary axes on XY plots is forced to the setting for the corresponding primary axis.

Note: Most moderate-sized non-bold fonts will have a pronounced aliasing problem at orientations other than horizontal or vertical on your display. They're ugly, in other words. The equivalent bold font will generally have a better appearance in this case. This applies mainly to the display and saved bitmaps; printed fonts will generally look good regardless of the orientation or font weight.

 

Related macro commands

DateFormat

DecimalDigits

LabelDirection

NSEW

NumberFormat

SplitDateTime

TimeFormat

 


Page url: https://www.dplot.com/help/index.htm?helpid_numberformats.htm