Referencing a date as text

  • Thread starter Thread starter Opinicus
  • Start date Start date
O

Opinicus

In sheet 1 of a spreadsheet I use there is a cell that gives
the current date as "MMM-YY" ("Oct-04", for example). In the
second sheet I refer to this cell with the formula
{=Sheet1!A1}, which gives me the date. What I want to do is
concatenate that date with the word " files" but entering
the formula as {=Sheet1!A1&" files"} converts the date to
its absolute number (such as "38621" or whatever). I've
tried using the "TEXT" function but I don't know what to put
in as the second (format_text) parameter.

How do I format this cell in the second sheet so that it
appears as "Oct-04 files"?

TIA
 
Back
Top