date format not change in custom

  • Thread starter Thread starter crapit
  • Start date Start date
C

crapit

Hi,
I use CONCATENATE fx to join 3 columns of data containing year month and
date. I copied the column containing the CONCATENATE function and paste as
value in a new column. I set custom to format as dd.mmm.yyyy in the new
column (My computer regional short date format is dd/mm/yyyy). but the
format didnt appear as dd.mm.yyyy. Instead, I had to edit or f2 the cell
then enter to make the conversion take place. What is unique abt the date
format?
 
Rather than CONCATENATE use something like:

=DATEVALUE(A1&"/"&B1&"/"C1)

This will create an actual date, rather than a text image that looks
like a date. Your custom date format will work after the date format
is recognized.

The order of A1&"/"&B1&"/"C1 may differ according to the 'short date'
setting on your computer.
 
=date(a1,b1,c1)
where a1 contains the year, b1 contains the month and c1 contains the day.

Format the cell the way you like.
 
Back
Top