Cell Format Changes When Data Is Entered - Not Conditional Formatt

G

Guest

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.
 
R

Ron Rosenfeld

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
 
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top