Formatted Cell Changes Format When Text Is Entered

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

 

[Simon Murphy]

Is there any code running?

 

[Guest]

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]

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:
(e-mail address removed)
cheers
Simon