IBM Support

very small numbers exporting to text as scientific notation

Troubleshooting


Problem

If I have a small number in Stats like say .0000000000375 is there a way to force Stats to not convert to Scientific notation of 3.75E-11? I want to save out to Tab-delimited text file but when it is exported as 3.75E-11 then imported into Excel or SPSS again they are coming in as string. Need to keep as decimal so when imported it reads as numeric and not string.

[{"Product":{"code":"SSLVMB","label":"IBM SPSS Statistics"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Not Applicable","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"18.0","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Historical Number

93393

Document Information

Modified date:
16 April 2020

UID

swg21486490