Excel Help

RatherDashing

Hey there H&A,

I've got some data I need to copy from a .txt file to an Excel spreadsheet, and one part of it in particular is causing problems... 67776e118. Excel seems to assume this is scientific notation, and if you paste that data from anywhere outside Excel, it will re-format it to read "6.78E+122". Once it shows that, no matter if you change the cell format to General, Text, or anything else, it will not go back to 67776e118. I've tried setting the column up as Text format prior to pasting, but it still does the same thing. Is there any way to make Excel stop doing this?

Thanks!

1ddqd

When I copy and paste it from the web page, I did Paste Special and said "Values Only" - worked.

Then, I imported a text file with only that string in it and formatted the column as "Text" - right after it asks about what delimiters to use (left default).

So...not really sure why you have that issue. Maybe just try to type it in manually?

Jaded

I just tried it here at work and your right, that does suck!
What did work for me was setting the cell in question to TEXT and then manually typing in the sequence.
Of course, if your posting a large string of information and not not just number then your results may vary.

I also typed:
I think that the sequence 67776e118 is awesome in an email and copied and paste it over with no adverse changes.

Not sure if any of this helps, but it may spark some more ideas.

RatherDashing

Yeah, the manual typing worked, but it's potentially thousands of lines, so that's out. And for some reason, I can't get "Paste Values" to work if whatever I've copied is not from inside Excel... kinda odd. But anyways, importing the data, and setting it as text before the import seemed to work, so guess this one can be locked. Thanks for the quick responses guys!