##
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.

## How to merge & combine .pdf to Excel pages

How can you merge and combine imported and converted .pdf to Excel 2007pages? [more inside]

## Need magic to convert PDF to Excel

OCRfilter: any software that will take a PDF and convert it to Excel? [more inside]

## Excel translated w/o my permission.

Excel - automatically converted my numerical values - [more inside]

## 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?

## Excel help

Mostly an Excel question (though maybe crossover to PDF). [more inside]

Page:
1