To be precise, we’re mistakenSeptember 18th, 2007 — ddelmoli
“Bother! We were mistaken!”
“To be precise: we’re a mistake.”
- Thomson and Thompson, Cigars of the Pharaoh
This post belongs to that category of dusty old bits of knowledge that lay deep in your head — stuff you never really thought would be useful, but you learned it anyway and it’s there, waiting for its turn in the sun.
So a friend of mine comes up to me and says, “What do you know about Excel?”. I say, “a little”. And she asked me to come look at a problem she’s having. She’s got a spreadsheet that she’s using to build a data entry form on (I know), and she’s got a cell where someone can put in an Account Number.
“Watch”, she says. And she types in 123456789123456789 and hits enter.
Excel immediately changes the cell contents to 123456789123456000, replacing the final 3 digits (789) with 3 zeros.
“Why is it doing that?’, she asks.
I make one change to the cell, and ask her to try it again. This time is works without replacing the final 3 digits.
I give you a 4 question quiz:
- What did I do?
- Why did I do it?
- What about Excel was causing it to do what it did?
- Why would this knowledge be useful to me at all when dealing with databases?