Formatted Cell Changes Format When Text Is Entered
 

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 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. The cell is not
conditionally formatted. Also the person who set up the worksheet is no
longer with the company.

Thank you.

Is there any code running?

"SundanceKidLudwig" wrote in
message ...
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 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. The cell is not
conditionally formatted. Also the person who set up the worksheet is no
longer with the company.

Thank you.

As far as I know there is not any code running. I am not completely sure
what that means though. There are no macros in the worksheet.
Thanks.

"Simon Murphy" wrote:

Is there any code running?

"SundanceKidLudwig" wrote in
message ...
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 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. The cell is not
conditionally formatted. Also the person who set up the worksheet is no
longer with the company.

Thank you.

Yes Macros is what I was thinking -either in that workbook or in you excel
somewhere

If you copy just that single cell to a new workbook does it still do it?
If you still can't sort it you can send me the file to look at:

cheers
Simon
"SundanceKidLudwig" wrote in
message ...
As far as I know there is not any code running. I am not completely sure
what that means though. There are no macros in the worksheet.
Thanks.

"Simon Murphy" wrote:

Is there any code running?

"SundanceKidLudwig" wrote
in
message ...
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 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. The cell is not
conditionally formatted. Also the person who set up the worksheet is
no
longer with the company.

Thank you.