Ask Your Question

cell range list with date content, show content format as number

asked 2019-01-07 10:11:05 +0200

rezvania gravatar image

updated 2019-01-07 10:34:17 +0200

Hello, I try to create a drop-down list dependent of a cell range with date contents, but when I open my list, contents show as numbers, however when I choose one of them, sit correct date format in the cell. do you have a solution?

edit retag flag offensive close merge delete


How did you create the list? Using Data Validity, or as Form Control Listbox with Data source? Anyhow, both variants for me display formatted dates if the source range contains dates. Validity in the format applied to the cell range, and the Listbox control in the default date format. For the Listbox control the linked target cell needs to be formatted as date.

erAck gravatar imageerAck ( 2019-01-15 19:18:20 +0200 )edit

Hi dear erAck :) I used of Data validity, and yeah, I understood that when I use of data source directly in the cell range, calc is able to apply date format in the dropdown, but when I use of a condition to choosing goal dates as my range, result in the dropdown shown like integer numbers. I found that it is fixable with TEXT() function, but it takes a long time to show the result.

rezvania gravatar imagerezvania ( 2019-01-17 07:06:06 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2019-01-07 12:07:04 +0200

If i understand your question, try to format the cells, Ctrl+1/numbers.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-01-07 10:11:05 +0200

Seen: 94 times

Last updated: Jan 07 '19