Format Cells Custom
type dd mmm yyyy
click OK

or use this formula in B2
=TEXT(A2,"dd mmm yyyy")
--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis

Am not a greek but an ordinary user trying to assist another



"MarcoT" wrote:

Need to save as this format and style for a connected system. will even
accept work arounds if they go through.