Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What is a field name in excel when making a pivot table? | Excel Discussion (Misc queries) | |||
Making a letter equal 1 formula | Excel Worksheet Functions | |||
How do I get "C4" field in Excel to equal the Worksheeet Name | Excel Discussion (Misc queries) | |||
How can I show all field data in a pivot table, instead of blank | Excel Discussion (Misc queries) | |||
Pivot Tables..I give up... | Excel Worksheet Functions |