[libreoffice-users] Re: converting txt to dates

Hi, I got a simple solution to this. My date format in excel sheet was like
12-04-2015.

Excel was not recognizing it as date or Formatting cell to Date was helping
me.

So I selected and Copied entire column of date to New Blank Word document.

  Then I Again copied the date column from word document and came back to my
original excel sheet.

Then right click and press Pest Special -->Paste as TEXT.

Done. Now Excel will recognize it as date and will allow you to format cells
any date format as you wish. 



--
View this message in context: 
http://nabble.documentfoundation.org/converting-txt-to-dates-tp4143826p4146086.html
Sent from the Users mailing list archive at Nabble.com.

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted