Knowledge Base

Welcome to The Carlisle Group's Knowledge Base.

Search or Ask a Question

This is a keyword search that looks for matching articles that contain one or more words specifically by a user in articles’ tags, title and content. Admin writes brief intro content here via admin end. If you are unable to find an answer to your issue, please submit an issue here.

Search the Knowledge Base

Back to Articles List

Scientific Notation formatted input from Excel | CAS

Added: 01/08/2013; Last Modified: 01/08/2013; Visits:2,272

Long integers may be formatted the following way in Excel:

In order to import these values correctly in CAS, import incoming field using a Numeric Data Type:

 

Then Click Run, enter the CAS Field Wizard, and Click Convert to Text:

 

Then adjust the Field Width input until the value appears correctly: