| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format date dd.mm.yyyy to dd/mm/yyyy | Excel Discussion (Misc queries) | |||
| change date format from dd/mm/yyyy to mm/yyyy | Excel Discussion (Misc queries) | |||
| yyyy-mm-dd date format? | Excel Discussion (Misc queries) | |||
| Date format yyyy/mm/dd | Excel Discussion (Misc queries) | |||
| how do I change date from mm/dd/yyyy to dd:mm:yyyy format in Excel | New Users to Excel | |||
Linear Mode
