I am no excel whiz kid.......so to make a long story short.
Downloaded some data from a database and excel dates are in 2 formats.....mm/dd/yyyy & mm-dd-yyyy. Tried to apply the =Text( A1, "mm/dd/yyy") formula did not help.
Tried the : format cells----->custom-----> .....etc, did not work
Looked over google did not really find anything that can help....
Any help appreciated or the MD is gonna fry my ass.......
| +85 | New Article: Dramatic Slide as UBS #22 (US) & New Leadership Desperately Needed | 13 | 23m |
| +72 | Wealthy Parents / Jaded | 23 | 12h |
| +55 | How are hours rn for SA (interns) | 30 | 3h |
| +46 | Venezuela Debt Restructuring - LAZ vs CVP | 22 | 9h |
| +42 | A COMPLETE GUIDE TO SUMMER INTERNSHIP RECRUITING | 9 | 5h |
| +37 | Boutique firm wants access to my LinkedIn? | 29 | 1h |
| +28 | Investment Banking in Mexico | 8 | 3h |
| +25 | MM bottom bucket bonus | 9 | 3d |
| +24 | UBS GIG, LevFin, FSG Interns working Sundays and 85 hour weeks their first week? | 12 | 1d |
| +21 | Excel macros for QOL formatting | 0 | 3d |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
are you sure excel is recognizing either format as actual dates or is it recognizing it as text? You might want to take one of them and manually type in a date in one of the cells and then see if your formula works.
Copy, paste special-format.
ok patrick you were right........so i basically copied the whole column and pasted them in as values only.....still the dates with the mm-dd-yyyy stayed as they are ( i assume because they are text right ? ) , went into format cells ........date......still nothing changed
When i pasted special by the way the dates with dd/mm/yyyy changed into numbers.....then i couldd reformat them...this thing is driving me mental
Thanks for both your help though
Download SAS and teach yourself how to program. Wins every time.
Beatae ab aut dolore debitis at. Ut accusamus illum a quidem quia qui accusantium. Dolores pariatur similique illum dolore.
Et ut voluptatem dolorum. Eum est repellat sunt consequuntur perspiciatis hic quos. Atque optio sint sed error necessitatibus vel. Voluptatem ea perspiciatis recusandae saepe nobis natus reprehenderit. Distinctio nulla eum non pariatur corrupti occaecati excepturi.
Blanditiis deleniti suscipit soluta omnis et sit. Laborum in perferendis voluptatem consequatur. Est eveniet labore quos ut aliquam. Natus et quidem minus ea est. Voluptatem possimus voluptatibus vel vitae qui at at. Magnam aut possimus molestias in atque.
Deserunt ut velit quos sit voluptates beatae. Quos quod a exercitationem. Expedita et veniam qui distinctio odit. Illo et nulla minus dolor ut recusandae ut ut.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...