Friday, May 6, 2011

yogi_ Change Date Text To Date Format

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com
PRASAD TR said:
Change Date Text to date format
How can we convert date format
From this
04-12-2011 04:37:00
04-12-2011 12:57:00
04-12-2011 11:37:00
To this
04-Dec-11
04-Dec-11
04-Dec-11
With out doing following things.
#should not copy past in notepad and copy back to excel.
#Should not remove Time.
it's not coming even if do Right click "Format Cells".
Kindly suggest . if past this data in sheet1 it should be automatically change to date format.
reference:
http://www.linkedin.com/groupItem?view=&srchtype=discussedNews&gid=3124035&item=52807150&type=member&trk=eml-anet_dig-b_pd-ttl-cn
---------------------------------------------------------------------------------