swag

L'autista
Administrator
Sep 23, 2003
84,960
did you try "paste special" that usually does the trick
Obviously not. Thanks for ruining my point, Bes. :(

Why is the "special" option the one that doesn't corrupt my data by automatically converting strings into numbers in scientific notation format? I mean, what percentage of Excel users actually know what scientific notation is?! Hell, even hexadecimal is far more common than that...
 

Enron

Tickle Me
Moderator
Oct 11, 2005
75,706
I got f*ed over by this very function yesterday when I imported some generated text user names for a test suite yesterday, and Excel decided to change the format of any string ending in "e#" (where '#' is one more more digits) into a number in scientific notation -- corrupting the data.

WTF, really. :(
See what happens when you diss Swayze.
 

Bjerknes

"Top Economist"
Mar 16, 2004
116,989
The latest Excel does piss me off quite a lot. They decided to change the features around from the last version in 2004, and it was basically like learning a completely new spreadsheet.

There's a lot of screwy things when you try to type in sophisticated formulae, too.
 
Jan 7, 2004
29,703
Obviously not. Thanks for ruining my point, Bes. :(

Why is the "special" option the one that doesn't corrupt my data by automatically converting strings into numbers in scientific notation format? I mean, what percentage of Excel users actually know what scientific notation is?! Hell, even hexadecimal is far more common than that...
:xmas: i feel so proud
 

Enron

Tickle Me
Moderator
Oct 11, 2005
75,706
So you're saying the ghost of Swayze is embedded into every copy of Excel?

Damn, no wonder why Office is so expensive.
Walt Disney wanted to be frozen. Swayze said "turn me into an Excel glitch and overprice your product". The kicker is only Woopie Goldberg can channel his ass out of your computer.
 

swag

L'autista
Administrator
Sep 23, 2003
84,960
Walt Disney wanted to be frozen. Swayze said "turn me into an Excel glitch and overprice your product". The kicker is only Woopie Goldberg can channel his ass out of your computer.
And the friggin' Chinese sure as hell aren't helping matters, spreading around Swayze's ectoplasm jism like H1N5 for a mere 5 RMB a copy down at the Silk Road flea market in Beijing.

Or maybe Swayze's ectoplasm jism is part of Windows Genuine Advantage to prevent illegal copying...
 

Firestarter

▀▄▀▄▀▄▀▄
Jul 15, 2006
25,814
I've already tried formatting it to General and Text. I don't even have that drop-down on the top toolbar HA! I have to right click and click "Format Cells".
I got f*ed over by this very function yesterday when I imported some generated text user names for a test suite yesterday, and Excel decided to change the format of any string ending in "e#" (where '#' is one more more digits) into a number in scientific notation -- corrupting the data.

WTF, really. :(
I don't have any other ideas really..
 

Nenz

Senior Member
Apr 17, 2008
10,497
Gonna hit the hay.
The Aussie Rules Grand Final is on tomorrow gonna have a lamb on the spit and some beers. You should all seriously consider watching it. Last time these two teams played it was one of the most amazing games I'd ever seen.

Night muchachos.
 

Users Who Are Viewing This Thread (Users: 0, Guests: 196)