Posted 20 April 2010 - 03:46 PM
Posted 20 April 2010 - 04:13 PM
Excel sees that long string of digits and converts to scientific notation, and as you noticed, it's not very helpful.
Do you have lots of these numbers to copy over? What's your data source?
One option is to set the cells you plan to copy the number into as "text" and then depending on the source, copy the number and right click and paste as "text."
Another option, depending on your data source is to split the number in half (into two different cells), so Excel sees each piece as a number, then concatenate the two cells, then format the results as text.
Posted 20 April 2010 - 04:21 PM
also, all the numbers are coming from an in-house program we use
time for trial n error, thanks dm for the suggestion
Posted 20 April 2010 - 04:26 PM
Sorry I don't have more to offer at the moment...
What file format does your system output the data?
Those numbers look just like the pre-paid gift card numbers I work with...
Best of luck to you and thanks for visiting GeeksToGo.
Posted 21 April 2010 - 09:10 AM
I forgot to mention that depending on how you are getting the data, you may want to try using the Import External Data wizard (if the source is a CSV file or similar). This would allow you to format the column with the numbers as "text" at the time of import.
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users