Forcing a specific date format
Hi Diane
You could enter in another column
=MID(A1,FIND(" ",A1)+1,2)&"-"&LEFT(A1,FIND(" ",A1)-1)&"-"&RIGHT(A1,4)
Copy down as required.
Once complete, copy the whole range of data and Paste SpecialValues to
convert from formulae to actual dates.
Regards
Roger Govier
DianeMcP wrote:
Update: I tried the custom and "dd-mmm-yy" - and it still does not change an
entry from Sept 20, 2005 to 20-Sept-05. Any other suggestions, anyone?
Diane
Hi Anne,
When I went back into the spreadsheet, I just chose one of the date formats
that were already there, and it showed 04-Mar-05....it was probably me that
assumed that the formatting in the code was dd-mon-yy.
I've gone back into it and used "custom" and put in dd-mmm-yy.
|