Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Im copying in data to a cell, when I copy it, the source info is this.

1000486818242033

it copies as this.

1.00949e+14

When i convert to number or text to columns it changes to this

1000486818242030

How can I fix that?

share|improve this question

migrated from stackoverflow.com Oct 20 '10 at 11:22

This question came from our site for professional and enthusiast programmers.

1 Answer 1

First set the cell format to text: Format > Cells.. > Number (Category Text)

Next paste it into the cell as text using: Edit > Paste Special... (As Text)

The trick is to ensure Excel sees the data as text all the time - it has a strong desire to convert anything that looks like it might be a number into a number - which in your case causes truncation.

For an external data source

Create an empty spreadsheet go to: Data > Import External Data > Import Data

Now connect your data source and step through the "Text import Wizzard" until you get to "step 3 of 3", here you can set the data type of each imported column. The default is "General", change this to "Text" and all should work fine.

share|improve this answer
    
the problem I have is im using a data connection and importing the data as well from Reporting Services. Its converted as a string but still bringing it in as a freaking number. –  Jeff Oct 12 '10 at 18:08
    
@Jeff. Added a few more hints for external data loads... –  NealB Oct 12 '10 at 19:27

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.