Making one field equal 2 others

[CMO]

3Hi,

I have 2 fields which I need to merge into 1. The formula I have so far is
=A1&"_"&A2

Cell A1 is text (Eg. AC) and A2 is a date (Eg. 01/01/2001). I need the
result to be AC_01/01/2001, but instead it shows up as AC_36892.

Is there any way of formatting the cell so it inputs the date rather than
the number of days since 01/01/1900?

Thanks

CMO

[Ardus Petus]

=A1&"_"&TEXT(A2,"dd/mm/yyyy")

HTH
--
AP

"CMO" <[email protected]> a écrit dans le message de news:
[email protected]...
> 3Hi,
>
> I have 2 fields which I need to merge into 1. The formula I have so far
> is
> =A1&"_"&A2
>
> Cell A1 is text (Eg. AC) and A2 is a date (Eg. 01/01/2001). I need the
> result to be AC_01/01/2001, but instead it shows up as AC_36892.
>
> Is there any way of formatting the cell so it inputs the date rather than
> the number of days since 01/01/1900?
>
> Thanks
>
> CMO

[Ron Rosenfeld]

On Fri, 26 May 2006 03:14:01 -0700, CMO <[email protected]> wrote:

>3Hi,
>
>I have 2 fields which I need to merge into 1. The formula I have so far is
>=A1&"_"&A2
>
>Cell A1 is text (Eg. AC) and A2 is a date (Eg. 01/01/2001). I need the
>result to be AC_01/01/2001, but instead it shows up as AC_36892.
>
>Is there any way of formatting the cell so it inputs the date rather than
>the number of days since 01/01/1900?
>
>Thanks
>
>CMO

=A1 & "_" & TEXT(A2,"dd/mm/yyyy")



--ron

[CMO]

Brilliant, thanks

"Ardus Petus" wrote:

> =A1&"_"&TEXT(A2,"dd/mm/yyyy")
>
> HTH
> --
> AP
>
> "CMO" <[email protected]> a écrit dans le message de news:
> [email protected]...
> > 3Hi,
> >
> > I have 2 fields which I need to merge into 1. The formula I have so far
> > is
> > =A1&"_"&A2
> >
> > Cell A1 is text (Eg. AC) and A2 is a date (Eg. 01/01/2001). I need the
> > result to be AC_01/01/2001, but instead it shows up as AC_36892.
> >
> > Is there any way of formatting the cell so it inputs the date rather than
> > the number of days since 01/01/1900?
> >
> > Thanks
> >
> > CMO
>
>
>