Format very small numbers as Scientific Notation

[#1]

I have a series of very small positive and negative values stored in oracle which I am attempting to display in crystal reports. Crystal is displaying all the values as 0. However if I turn the max decimal places on I will see some values as 0.00...00XY.

I would like these values simply displayed as scientific notation with something like 1.2E-12.

It seems crystal automatically converts very large values to SN, but not very small values?

[former_member11696]

CR has an internal limit of 15 digits plus one for the sign of the number. Only work around is to use a stored procedure and either convert them to a string or break the numbers into parts and using those multiple fields in the Designer by placing them next to each other.