Me also long time past.

Gord

On Thu, 19 Jul 2007 17:42:52 -0500, Dave Peterson
wrote:

That's one of the autocorrect entries that I've removed (for this very reason).

Dave Thomas wrote:

Be very careful with dots (periods) in Excel. If you type in "." (1 dot),
you get 1 dot. If you type in ".." (2 dots) you get 2 dots. If you type in
"..." (3 dots) you get ellipsis (...), not 3 dots. If you type in "...." (4
dots), you get ellipsis (...) and 1 dot. If you type in "....." (5 dots) you
get ellipsis (...) and 2 dots. If you type in "......" (6 dots), you get
ellipsis (...) and ellipsis (...). If you type in "......." (7 dots), you
get ellipsis (...), ellipsis(...) and 1 dot. Etc.

A dot is code 46, ellipsis is code 133. If you have a cell filled with dots
beside a cell filled with ellipses, you will see the spacing between the
dots and the ellipses is uniform, but careful inspection will reveal that
cells look different.There is a slightly wider space following the
ellipsis.This space is wider than the space between dots.

"nae" wrote in message
...
can I do a dot count in a cell?