Decimal points are so very tiny, and yet so important.
One of my online service providers “accidentally” charged me 82.5% sales tax instead of 8.25%.
To quote the Texas governor: “Oops.”
The placement of that little dot caused quite a ruckus. Fortunately, I’m getting a refund.
Sometimes you think you have a decimal point there, but it’s really a speck of dirt on your computer screen. Moral of the story: keep you screen clean.
I’ve run across a number of incidents of double periods at the end of the sentence. Sometimes you just have to crane your neck and squint your eyes or adjust your bifocals to make sure you catch all these tiny extra dots and eliminate them.
Here are some other “oopsies” that happen frequently in spreadsheets.
Sometimes the letter O is entered instead of a zero.
Sometimes the exclamation point ( ! ) is entered instead of the number one – or perhaps a lower case L ( 1 vs. l – it’s hard to tell).
But Excel knows an L when it sees one, and it considers it a letter, not a number, so your equations and formulas won’t work right.
Keep this tip in mind the next time you see your spreadsheet doing something funny. You just might have an O instead of a 0.
Funny Typo of the Day: Gammy Ray
Profound Quote of the Day
“The small wisdom is like water in a glass: clear, transparent, pure.
The great wisdom is like the water in the sea: dark, mysterious, impenetrable.”
― Rabindranath Tagore, India’s first Nobel Prize poet, 1861-1941