Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Jun 2003
    Thanked 0 Times in 0 Posts

    UN-Wanted Format Change (Excel 97 SR-2)

    I have 2 columns which are formatted custom (dd/mm/yyyy) which I am Concatenating together... (one of the columns is always blank)... so I can merge two lists of dates into one. When I use the formula: =IF((EXACT(A2,B2)),B2,CONCATENATE(A2,B2)) it works fine with the EXACT test... and the first date when both columns are the same... yet when one is blank and it fails to the False response... it gives me the date as a number... not in the custom date format...
    The cell still shows as formatted custom (dd/mm/yyyy), but it gives a number (37868) instead of the date (04/09/2003). How do I fix this?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 28 Times in 28 Posts

    Re: UN-Wanted Format Change (Excel 97 SR-2)

    CONCATENATE glues strings together, the resulting value is always a string. To enable Excel to display it as a date, you must convert the result to a number:


Posting Permissions

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