6 posts tagged with conversion and Excel.
Displaying 1 through 6 of 6. Subscribe:

Excel imported my dates as day-month instead of year-month. How to fix?

How do I fix this? I "imported" a table from a PDF (big mistake). In the pdf, the dates were formatted as AA-BB, where AA was the month and BB was the year. Excel interpreted that as AA is the month and BB is the day, and gave them all 2013 as the year. So now the date reads as 11-Jan instead of Jan 2011. I no longer have access to the original dataset because I only just noticed the mistake. I am using Excel 2010 on Windows.
posted by rebent on Aug 26, 2013 - 6 answers

How to merge & combine .pdf to Excel pages

How can you merge and combine imported and converted .pdf to Excel 2007pages? [more inside]
posted by ~Sushma~ on Nov 30, 2010 - 5 answers

Need magic to convert PDF to Excel

OCRfilter: any software that will take a PDF and convert it to Excel? [more inside]
posted by bartleby on Oct 23, 2007 - 9 answers

Excel translated w/o my permission.

Excel - automatically converted my numerical values - [more inside]
posted by seeminglyshy on May 14, 2007 - 8 answers

Excel-fu needed.

Excel problem. How do I convert the following number format. 106026 where from left - first digit is CENTURY. Next two are YEAR and last three are JULIAN DAY. So last example is CENTURY 1, YEAR 06, and 26th Julian day of the year. I would like to convert to to mm/dd/yy. Anyone have good Excel-fu for this?
posted by thimk on Jan 26, 2006 - 10 answers

Excel help

Mostly an Excel question (though maybe crossover to PDF). [more inside]
posted by dobbs on Jun 15, 2004 - 3 answers

Page: 1