Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Formatting in Drop Down Lists
I am using various drop down lists in my spreadsheet however when a user
types text rather than selecting the entry from the drop down list the formatting is not constant. For example. if Jun (proper case) is listed in my drop down list, the user can enter jun (all lower case) in the cell and it accepts it. The pivot table reports then have two distinct entries, Jun and jun. How can I require the formatting to be consistent with that of the drop down list? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Drop Down Lists Help | Excel Worksheet Functions | |||
Drop down lists in excel | Excel Discussion (Misc queries) | |||
Excel Drop-down lists | Excel Discussion (Misc queries) | |||
Excel drop down lists | Excel Discussion (Misc queries) | |||
Multiple lists with repeated values for dependet drop down lists | Excel Worksheet Functions |