Haw to delete or edit Customize List in Option window in Excel
 

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.

Haw to delete or edit Customize List in Option window in Excel
 

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.

Haw to delete or edit Customize List in Option window in Excel
 

On Aug 21, 4:28 am, 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.

That sounds more like a format problem. Change the cell's format to
General or a number format.

Custom Lists will only affect you if you are making a list in your
data. And you can't delete the built-in lists, only those you have
created.