Cell Format Changes When Data Is Entered - Not Conditional Formatt
 

I am using a worksheet that someone else set up. When I enter information in
a cell the format changes. I clicked "Undo" and then checked cell format
for the number and alignment format and both are set to general and there is
an upper border to the cell. When I enter text the border disappears and the
text is centered. I cannot determined what is causing this to happen. Also
the person who set up the worksheet is no longer with the company. The
conditional formatting is not turned on.

On Thu, 29 Sep 2005 14:51:01 -0700, "SundanceKidLudwig"
wrote:

I am using a worksheet that someone else set up. When I enter information in
a cell the format changes. I clicked "Undo" and then checked cell format
for the number and alignment format and both are set to general and there is
an upper border to the cell. When I enter text the border disappears and the
text is centered. I cannot determined what is causing this to happen. Also
the person who set up the worksheet is no longer with the company. The
conditional formatting is not turned on.

Look for a worksheet (or workbook) triggered event.


--ron

What is a "triggered event"? The worksheet has no macros or any conditional
formatting.
Thanks.

"Ron Rosenfeld" wrote:

On Thu, 29 Sep 2005 14:51:01 -0700, "SundanceKidLudwig"
wrote:

I am using a worksheet that someone else set up. When I enter information in
a cell the format changes. I clicked "Undo" and then checked cell format
for the number and alignment format and both are set to general and there is
an upper border to the cell. When I enter text the border disappears and the
text is centered. I cannot determined what is causing this to happen. Also
the person who set up the worksheet is no longer with the company. The
conditional formatting is not turned on.

Look for a worksheet (or workbook) triggered event.


--ron