Happy to help Gerry............thanks for the feedback............

Vaya con Dios,
Chuck, CABGx3


"Gerry Cornell" wrote in message
...
CLR

I tested what you suggested and it worked. Thank you.

--

Regards.

Gerry
~~~~
FCA
Stourport, England
Enquire, plan and execute
~~~~~~~~~~~~~~~~~~~



CLR wrote:
Hi Gerry...........

As long as you pre-format the empty cells as I've suggested, the
entry of new values will also be right-aligned. Please describe
what
you've tried and how it is acting differently than what I've
described........

Vaya con Dios,
Chuck, CABGx3



"Gerry Cornell" wrote:

CLR

Thanks but that only corrects those cells not conforming. I am
looking for a solution where that becomes unnecessary?.

The same problem also arise with alphanumeric reference numbers.

--

Regards.

Gerry
~~~~
FCA
Stourport, England
Enquire, plan and execute
~~~~~~~~~~~~~~~~~~~