LinkBack URL
About LinkBacks
SAP has the date when I export to excel as 10.9.2014 and excel is not recognizing this as a date, how can I get it to recognize it as a date so that I can sort it... surely there is an easy way to do this.
Can someone please help
SAP has the date when I export to excel as 10.9.2014 and excel is not recognizing this as a date, how can I get it to recognize it as a date so that I can sort it... surely there is an easy way to do this.
Can someone please help
If date is in A1, maybe this in B1: =DATEVALUE(SUBSTITUTE(A1, ".", "/"))
Format that cell to the date format you desire, then copy down as needed.
You can then COPY > PasteSpecial > Values over the original dates...
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Another trick you can try in place:
1) Highlight the column of dates
2) Click on Data > Text To Columns > Delimited > Next > (uncheck all options) > Next > Date (DMY) > OK
Hi,
I am doing this with the help of, Select data column than Ctr+F search for . replace with –
It will convert to date
Regards
Amar K
Formula:
Please Login or Register to view this content.
Try this
Considering that you have data in E8
Punnam
Be careful with the various options, converting straight from text to dates with a formula can lead to Excel getting MONTH and DAYS mixed up. The TEXT TO COLUMNS trick I've outlined lets you specifically note that the original text string should be converted using DMY.
The text to column is perfect!!!!! Did know about that thanks a ton...
If you are using ctrl+F your life is miserable there is always an easier way...
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks