Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Feb 2003
    Posts
    363
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Date format in combobox (2000)

    I have a combobox from the control toolbox. The list-fill range is named DateRcvd (which contains 6 dates formatted mm/dd/yy ).
    When I click the arrow button on the combobox, the dates appear with the correct format.
    However, the date shown in the Linked Cell appears in Serial format even after I format the cell mm/dd/yy.

    I couldn't find a format property in the Properties dialog.
    Is there another way to format the Linked Cell?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Date format in combobox (2000)

    The result of a combo box will be text. Say that the linked cell is D1. In cell E1, enter the formula =VALUE(D1) and format E1 as a date. If you like, you can hide the column with the linked cell.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •