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.......
| +137 | Piper Sandler in talks to acquire PWP | 61 | 4h |
| +125 | Interns without return offers, careers & perspective | 11 | 8h |
| +114 | UBS Appears to be Exploring Sale | 14 | 11h |
| +102 | Just One More Year | 11 | 2d |
| +82 | Are all these UBS postings bullshit? | 21 | 10h |
| +70 | Bringing Deals as a Vice President | 20 | 10h |
| +66 | Paradise Is Paradise | 5 | 16h |
| +37 | Q&A | Investment Banking Analyst, UBS | 2 years in investment banking | 11 | 1d |
| +35 | Q&A | Incoming Associate, Bulge Bracke, AMA: Career switcher (tech sales/BD → MBA → BB TMT IB), return offer | (6 years in Tech/Accounting) | 6 | 4d |
| +32 | M&A is Paradise | 1 | 2d |
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.
Vel aperiam nihil nam a sed provident. Consequatur repudiandae voluptas at soluta aut harum expedita hic. Distinctio dolores voluptas totam modi distinctio animi facilis.
Dolorum tempore blanditiis ut voluptates omnis. Nihil odit recusandae aliquam consequatur maiores eius eveniet. Neque nobis a a accusamus consequatur est rerum.
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...