format date & number within a cell containing text

[sam]

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?

 

[Pete_UK]

Try this:

="text to appear with date " & TEXT(Q5,"mm/dd/yyyy")

or

=INT(L5) & " text to describe number"

Hope this helps.

Pete

 

[Stefi]

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


„sam†ezt írta: