Concatenated Dates?

Hi,

I'm trying to solve a problem whereby dates are being transferred to their
1900 system value when I don't want them to.

Let's say we have the following cells:

A1 contains 01-Mar-06 [01/03/2006 with custom format dd-mmm-yy]
A2 contains 15-Jun-06 [15/06/2006 with custom format dd-mmm-yy]

A3 contains =A1&" to "&A2

A3 is a simple concatenation, with the intention of returning:

01-Mar-06 to 15-Jun-06

However, it gives: 38777 to 38883

So, how can I get the concatenation to use the formatted date & not the 1900
system value? I've tried all sorts of date formats but it always returns the
5-digit numbers.

Any help greatly appreciated.


-Jay-

Try this:

A3: =TEXT(A1,"dd-mmm-yy")&" to "&TEXT(A2,"dd-mmm-yy")

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Jay" wrote:

> Hi,
>
> I'm trying to solve a problem whereby dates are being transferred to their
> 1900 system value when I don't want them to.
>
> Let's say we have the following cells:
>
> A1 contains 01-Mar-06 [01/03/2006 with custom format dd-mmm-yy]
> A2 contains 15-Jun-06 [15/06/2006 with custom format dd-mmm-yy]
>
> A3 contains =A1&" to "&A2
>
> A3 is a simple concatenation, with the intention of returning:
>
> 01-Mar-06 to 15-Jun-06
>
> However, it gives: 38777 to 38883
>
> So, how can I get the concatenation to use the formatted date & not the 1900
> system value? I've tried all sorts of date formats but it always returns the
> 5-digit numbers.
>
> Any help greatly appreciated.
>
>
> -Jay-
>
>