Get Your Numbers Right
Returns the SD (significant digits) edition of xlPrecision.
The value returned by xlpSD is the maximum number of significant digits that can be returned.
Values returned by xlpSD range from 25 to 2,147,483,648.
The Free Edition of xlPrecision 3.0 and later returns 500. The Free Edition of xlPrecision 2.x returns 150.
The SD edition can also be viewed on the About box. From Excel's Tools menu, choose xlPrecision | About xlPrecision.
xlpSD was introduced in xlPrecision 2.0.
|=xlpSD()||SD (significant digits) edition of xlPrecision.|