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.......
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.
Quia at vitae id alias laborum inventore quisquam. Dolor illum sunt animi sapiente deserunt pariatur.
Sed error aut nostrum. Amet animi aspernatur aut qui assumenda et non. Temporibus et deleniti et. Et nulla eos quia ut. Nam a sunt veniam odit eos. Minus iure cupiditate reiciendis a officiis ipsa illo.
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...