Forms

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created a form from a list in Excel 2000 - one of my column headings is 23-sep-03 but on my form it shows as the serial number eg: 35279. Can this be changed on the form? It is displayed correctly in the cell.

Thanks a million in advance to anyone who can help...

Ann
 
Is this a form created from cells on the worksheet, from the Forms toolbar,
or the Control toolbar?

--
Greeting from the Gulf Coast!
http://myweb.cableone.net/twodays
Ann said:
I have created a form from a list in Excel 2000 - one of my column
Click to expand...
headings is 23-sep-03 but on my form it shows as the serial number eg:
35279. Can this be changed on the form? It is displayed correctly in the
cell.
 
You may want to use a line like:

combobox1.value = format(combobox1.value,"dd-mmm-yy")

But without answers to Jim's questions, I'm not sure if this is ok.
 
Back
Top