Some of the custom lists are default Excel lists and cannot be deleted.

i.e. weekdays and months are default.

What type of number are you entering?

Data like 1-2 are interpreted as dates by Excel.

Preface with an apostrophe to enter this type of data.


Gord Dibben MS Excel MVP

On Thu, 21 Aug 2008 02:28:00 -0700, Girina
wrote:

I have a problem with Customize List in Excel. I want to delete or edit
Customize List in Option window in Excel. But the Delete button is not
visible. At attempt to write down number in a cell, the number is
automatically translated in a format of date.

Irina Gogelia
Georgia.Tbilisi.