Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel will not show all text entered in a Cell merged from 9 rows | Excel Discussion (Misc queries) | |||
How do I set Excel cell format to "Text" from VB.NET? | Excel Discussion (Misc queries) | |||
Entered text value equals a number I specify in another cell | Excel Worksheet Functions | |||
Custom format a text cell with square brackets: [ ] ? | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |