date format not change in custom

[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?

 

[google]

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.

 

[Dave Peterson]

=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.