Is it possible to display date in a column that is not date column?

New Contributor

I'm thinking to combine multiple information into one column, but I'm having trouble with displaying date value, which will be shows as serial number.

 

For example, I would like to do like this within a single cell:

==

First test: 2022/5/31  "Test was already performed"               

Second test: 2022/6/2    "Test will be performed soon" 

==

 

Is there a way for this?

1 Reply

@fgtom whilst I can't think why you would want to combine columns as it will make filtering, views etc much more difficult, it is possible even with a DateTime column by creating a calculated column using a formula like this:

 

=CONCATENATE(Title&" "&TEXT([Review Date],"dd/MM/yyyy")&" "&Region&" "&Result)

 

concatenate3.png

Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)