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

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

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

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.

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

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.