ExcelBanter - Date in Concatenation

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Date in Concatenation (https://www.excelbanter.com/excel-discussion-misc-queries/159019-date-concatenation.html)

FARAZ QURESHI

Date in Concatenation

I have following values in cells
A1=Faraz
A2=(Current Date)
A3=(Current Time)

When I type the formula:
="This file was created by "&A1&" on "&A2&" at "&A3

The result line shows date and time in format of numbers and fractions.

Any help would be highly obliged.

Thanx!

Mike H

Date in Concatenation

Maybe

=A1&" "&TEXT(A2,"dd:mm:yyyy")&" "&TEXT(A3,"HH:MM")

Mike

"FARAZ QURESHI" wrote:

I have following values in cells
A1=Faraz
A2=(Current Date)
A3=(Current Time)

When I type the formula:
="This file was created by "&A1&" on "&A2&" at "&A3

The result line shows date and time in format of numbers and fractions.

Any help would be highly obliged.

Thanx!

Gord Dibben

Date in Concatenation

="This file was created by "&A1&" on "&TEXT(A2,"mm/dd/yyyy at ")&TEXT(A3,"
hh:mm:ss")

Gord Dibben MS Excel MVP

On Thu, 20 Sep 2007 02:16:24 -0700, FARAZ QURESHI
wrote:

I have following values in cells
A1=Faraz
A2=(Current Date)
A3=(Current Time)

When I type the formula:
="This file was created by "&A1&" on "&A2&" at "&A3

The result line shows date and time in format of numbers and fractions.

Any help would be highly obliged.

Thanx!

All times are GMT +1. The time now is 04:01 PM.