In Excel 2007, some cells get values from a dropdown list, using the data
validation feature. Then, I use the custom format of ";;;" for the range of
cells that pass the values to the dropdown list, in order to hide their
contents from the user.

I'm pretty sure, that the first time I've tested it, the dropdown lists were
working alright. However, at a later time, after reopening the workbook, the
contents of all the dropdown lists that get values from cells with numbers
are disappeared. I now only see the contents of a dropdown list that gets
values from cells with text.

What have I done?
Help please!
--
geotso
---- ---- --- -- -- - -
Please, remove hyphens to contact me
---- ---- --- -- -- - -