ExcelBanter - Combine date with text

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Combine date with text (https://www.excelbanter.com/excel-worksheet-functions/19402-combine-date-text.html)

SVC

Combine date with text

i have entered this in a cell

="Printed On : "& TODAY()

for which i get the result as

Printed On : {some serial number} what i want is

Printed On : {date in the date format as dd/mm/yyyy}

please help.

Dave Peterson

="Printed on: " & text(today(),"dd/mm/yyyy")

SVC wrote:

i have entered this in a cell

="Printed On : "& TODAY()

for which i get the result as

Printed On : {some serial number} what i want is

Printed On : {date in the date format as dd/mm/yyyy}

please help.

--

Dave Peterson

All times are GMT +1. The time now is 05:51 AM.