Making one field equal 2 others
 

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

Making one field equal 2 others
 

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

HTH
--
AP

"CMO" a écrit dans le message de news:
...
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

Making one field equal 2 others
 

On Fri, 26 May 2006 03:14:01 -0700, CMO 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

Making one field equal 2 others
 

Brilliant, thanks

"Ardus Petus" wrote:

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

HTH
--
AP

"CMO" a écrit dans le message de news:
...
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