="text to appear with date"&TEXT(Q5,"mm/dd/yyyy")
=INT(L5)& " text to describe number"
Regards,
Stefi


€žsam€� ezt Ã*rta:

I'm trying to create cells in a worksheet which are text with calculated
dates & numbers imported from other cells in the workbook. My problem is
that the date reverts to the numeric form & the numbers have many decimal
places.
I would like to retain the mm/dd/yyyy date format & display only whole
numbers. The formula I am using to import the information is:
="text to appear with date" & Q5
or
=L5& " text to describe number"

What can I do to change the results?