Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Select Custom for Display in Column Properties dialog or Format Cell dialog. Choose ##+## or #+##M from Custom Display combo.

Image RemovedImage Added

 

Custom DisplayDescription
*nn*nn is to specify the number of significant digits
.nn.nn is to specify the number of decimal places 
SScientific
EEngineering
##+##123 will be display displayed as 01+23
#+##M123 will be display displayed as 1+23M

Note: For graph's tick label, linear referencing numeric display is also supported by setting Display to Custom in the page under Tick Labels in Axis Dialog.