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.......
| +518 | Change My Mind: Banks Shouldn’t Hire Foreigners at All | 120 | 2h |
| +317 | Article - UBS’ Investment Bank Keeps Losing Ground | 40 | 2h |
| +301 | Don’t work at UBS - UBS Sucks | 30 | 1h |
| +77 | Should My Intern Get a Return Offer? | 29 | 36m |
| +60 | When to Leave Office as Intern | 8 | 3d |
| +49 | Best IB Group Overall? | 28 | 2h |
| +38 | Would you rather be a Touse Squid or a Bouse Mogger in IB | 2 | 3d |
| +33 | What do you say to ppl who don’t know EVR/LAZ/CVP/PJT | 28 | 6h |
| +31 | STEM student lost in London IB recruiting | 17 | 1d |
| +29 | F*ck it I'm Going to Med School | 10 | 14h |
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.
Esse harum aut rem. Quam natus voluptates in repudiandae. Repudiandae delectus maxime voluptas et corporis.
Debitis et voluptas dolores reprehenderit. Est facere doloremque sit quam. Nisi perferendis assumenda dolorem saepe autem quaerat.
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...