Formatted Cell Changes Format When Text Is Entered

  • Thread starter Thread starter Guest
  • Start date Start date
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 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.
 
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
 
Back
Top