Formating Data in a Formula

  • Thread starter Thread starter lj
  • Start date Start date
L

lj

Hi, I would like to know if there is a way to format the returned data
from a specific section of a formula. What I would like to do is
concatenate a date with other data in my spreadsheet. However, when I
try and do this - CONCATENATE (C2,C3) where C2 is the date, C2 is
displayed in the cell in the numeric value of the date. Is there a way
to format C2 as the actual date value within the formula? Is there any
other way that I can get the data to display in the format I'm
looking for? Thanks.
 
Back
Top