Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Validation - List formatting
The source for my list has a simple format (text alignment - right
justified). How can I keep that format active when using the data validation dropdown? Thanks, Gordon |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Validation - List formatting
Format the cell with the validation the same way
-- Regards, Peo Sjoblom "Gordon Smith" wrote in message ... The source for my list has a simple format (text alignment - right justified). How can I keep that format active when using the data validation dropdown? Thanks, Gordon |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Validation - List formatting
I have both the cell which has the validation/list and the list itself (all
entries) formatted as right justified. The cells which make up the list look correct, the value placed in the referencing cell shows up correctly once a value has been picked, but the dropdown itself has the values left justified. Thoughts? Thanks "Peo Sjoblom" wrote in message ... Format the cell with the validation the same way -- Regards, Peo Sjoblom "Gordon Smith" wrote in message ... The source for my list has a simple format (text alignment - right justified). How can I keep that format active when using the data validation dropdown? Thanks, Gordon |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Validation - List formatting
I see, there is no way of changing that
-- Regards, Peo Sjoblom "Gordon Smith" wrote in message ... I have both the cell which has the validation/list and the list itself (all entries) formatted as right justified. The cells which make up the list look correct, the value placed in the referencing cell shows up correctly once a value has been picked, but the dropdown itself has the values left justified. Thoughts? Thanks "Peo Sjoblom" wrote in message ... Format the cell with the validation the same way -- Regards, Peo Sjoblom "Gordon Smith" wrote in message ... The source for my list has a simple format (text alignment - right justified). How can I keep that format active when using the data validation dropdown? Thanks, Gordon |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
data validation list: how do i 'force' a user to enter data from the list? | Excel Discussion (Misc queries) | |||
data validation list: how do i 'force' a user to enter data from the list? | Excel Discussion (Misc queries) | |||
data validation invalid in dynamic validation list | Excel Discussion (Misc queries) | |||
data validation invalid in dynamic validation list | Excel Worksheet Functions | |||
Data Validation - List - keeping the format of the list - shading | Excel Discussion (Misc queries) |