Use this in a helper column:

=TEXT(A1,"dd mmm yyyy")

then copy down. Fix the values and then copy the values over to the
original column and then delete the helper column.

Hope this helps.

Pete

On May 5, 12:39*pm, MarcoT wrote:
Need to save as this format and style for a connected system. will even
accept work arounds if they go through.