How do I save date format: dd mmm yyyy as a csv file?

M

MarcoT

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

Pete_UK

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
 
F

Francis

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
 
Top