Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003
I have inherited an XLS. In one column if I enter HIGH or LOW in lower case
it changes immediately to upper case. Anything else I enter stays in lower case. I see no formulas or macros. I checked autocorrect and high or low is not in the list to be changed to upper case. There is no data validation on the cells. See no smart tags not do I see it as a drop down list. What could I be missing? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003
On Apr 13, 3:40 pm, FLP wrote:
I have inherited an XLS. In one column if I enter HIGH or LOW in lower case it changes immediately to upper case. Anything else I enter stays in lower case. I see no formulas or macros. I checked autocorrect and high or low is not in the list to be changed to upper case. There is no data validation on the cells. See no smart tags not do I see it as a drop down list. What could I be missing? Have you tried formatting the cell to "Text" (Format Cell :: Number Tab :: Category :: Text)? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003
right click on the tab and select view code
there is probably vba code for that sheet. "FLP" wrote: I have inherited an XLS. In one column if I enter HIGH or LOW in lower case it changes immediately to upper case. Anything else I enter stays in lower case. I see no formulas or macros. I checked autocorrect and high or low is not in the list to be changed to upper case. There is no data validation on the cells. See no smart tags not do I see it as a drop down list. What could I be missing? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
import Excel 2003 file into Outlook 2003 - NO NAMED RANGES?? | Excel Discussion (Misc queries) | |||
Copying Excel 2003 Selection into Outlook 2003 HTML E-Mail Message | Excel Discussion (Misc queries) | |||
Upgrade from Excel 2000 to Excel 2003 without MS Office 2003? | Excel Discussion (Misc queries) | |||
Exporting addresses from excel 2003 to outlook 2003 | Excel Discussion (Misc queries) | |||
Excel 2003 Database Driver Visual FoxPro 7 on Server 2003. | Excel Discussion (Misc queries) |