CONCATENATE TEXT & FORMULAS

LANIP · Feb 26th, 2002, 01:49 PM

I'm trying to concatenate a cell with text and a cell that contains a formula. The concatenate cell is working, however, the cell with a formula is in date format (mm/dd/yy), but when it is added to the text it shows as a numerical date (ex: 01/14/02 = 37270). How do I get the date to show in the destination cell in the mm/dd/yy format? I need destination cell to look like this : Week of 01/14/02 not Week of 37270.

Mark W. · Feb 26th, 2002, 01:50 PM

Quote:

On 2002-02-26 12:49, LANIP wrote:
I'm trying to concatenate a cell with text and a cell that contains a formula. The concatenate cell is working, however, the cell with a formula is in date format (mm/dd/yy), but when it is added to the text it shows as a numerical date (ex: 01/14/02 = 37270). How do I get the date to show in the destination cell in the mm/dd/yy format? I need destination cell to look like this : Week of 01/14/02 not Week of 37270.

=A1&TEXT(B1," mm/dd/yy") where A1 contains your text and B1 contains your date value.

IML · Feb 26th, 2002, 01:51 PM

try
="week of "&TEXT(A1,"mm/dd/yy")

good luck

Quote:

On 2002-02-26 12:49, LANIP wrote:
I'm trying to concatenate a cell with text and a cell that contains a formula. The concatenate cell is working, however, the cell with a formula is in date format (mm/dd/yy), but when it is added to the text it shows as a numerical date (ex: 01/14/02 = 37270). How do I get the date to show in the destination cell in the mm/dd/yy format? I need destination cell to look like this : Week of 01/14/02 not Week of 37270.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 26th, 2002, 01:49 PM	#1
LANIP New Member Join Date: Feb 2002 Posts: 1	I'm trying to concatenate a cell with text and a cell that contains a formula. The concatenate cell is working, however, the cell with a formula is in date format (mm/dd/yy), but when it is added to the text it shows as a numerical date (ex: 01/14/02 = 37270). How do I get the date to show in the destination cell in the mm/dd/yy format? I need destination cell to look like this : Week of 01/14/02 not Week of 37270.