Those Pesky Little Dots

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


2 Responses to “Those Pesky Little Dots”

  1. Rhonda Says:

    One trick for seeing if it’s a real dot vs a speck of dust is to magnify the document. When I’m editing a long document over many hours, I’ll zoom in to about 150%. Not only does it help my eyes and neck/shoulders, but I can easily distinguish between a real dot and a dirt speck 😉


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: