I
Ian Francis
I have a ComboBox used on my spreadsheet that lets the end user select dates
from a drop down menu. All the dates are out of site to the end user and
listed in 3-Apr-05 format in the cellrange the ComboBox draws from. The
problem is that after you make the date selection it changes the format to
decimal (ie. 38445).
Does anyone know why this is happening or how to make it display in date
format? Also, I need to keep it in date format as other cells are using the
date in a formula.
Thanks,
Ian
from a drop down menu. All the dates are out of site to the end user and
listed in 3-Apr-05 format in the cellrange the ComboBox draws from. The
problem is that after you make the date selection it changes the format to
decimal (ie. 38445).
Does anyone know why this is happening or how to make it display in date
format? Also, I need to keep it in date format as other cells are using the
date in a formula.
Thanks,
Ian