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


G

Girina

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.
 
Ad

Advertisements

G

Gord Dibben

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
 
Ad

Advertisements

S

Spiky

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top