View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.programming
Dick Watson Dick Watson is offline
external usenet poster
 
Posts: 18
Default myCell = CStr(SomeDigits) ?

Checked that very early on. It is just 5 ASCII characters within 0 .. 9.
Exactly what's in the database.

"Rick Rothstein" wrote:

Does the entry returned by the query perhaps have a space (or some other
non-visible character) in front or after the number? You should be able to
check with the LEN function. If it is an "invisible" character of some sort,
then this VB code should uncover it...