0
votes
2answers
63 views

Convert pdf to excel

I have a pdf of 18,000 pages of data that I need to work with for a project. I'm trying to convert it to an excel spreadsheet. I can't use Acrobat because it's just for a summer project thus I don't ...
0
votes
1answer
1k views

How can I get the displayed value of a cell in MS Excel ( for text that was converted to dates)?

How can I get the displayed value of a cell in MS Excel ( for text that was converted to dates)? Excel File Origin I have an Excel file that was originally a CSV file. At this time I don't have ...
5
votes
2answers
694 views

How to convert embedded excel sheet to word table?

We receive word documents from clients that will sometime contains Embedded Excel Object(sheet) and we need to convert them to word table so that we can then import the documents in InDesign properly. ...
0
votes
1answer
42 views

I've deleted some cells and cleared everything out and it keeps reverting back to DATE format

I've never changed formatting to date: I always keep it in General unless I need to make it different. Since my last Update, everything now changes to date when I either copy, paste, or when I ...
4
votes
0answers
54 views

Excel 2007 doesn't preserve asian characters when converting to csv [duplicate]

I am trying to save a spreadsheet as a CSV file. The file consists of korean characters, and the resulting csv has those characters literally converted to question marks (0x3F). I am running on an ...
0
votes
3answers
225 views

Method to convert Zipcodes to Addresses

At my mother's workplace, she often accesses the database and pulls out numbers in order to form reports. From selecting data Oracle to outputting reports in Excel format, she has come across this ...
0
votes
1answer
58 views

Want to convert PDF files to XLS and then bring those XLS to a particular format

Have some 1000+ PDF files. Want to convert those files to XLS and then bring those XLS files to a format which can be used to export XLS data to either existing or new MySQL tables. Can this be ...
0
votes
1answer
622 views

How to convert currencies in Excel based on historical conversion rates?

I want to make a small program in Excel that allows the user to convert certain currencies (USD, Euro, AED, CHF and GBP) to Kuwaiti dinar. The user can set the amount, the currency and the month, and ...
3
votes
3answers
6k views

Batch convert XLS to XLSX

I have to work with an old application that can only export XLS files and I write programs in .Net using the EPPlus library that is only capable of reading XLSX files. What is the easiest way to ...
0
votes
0answers
94 views

Name a abbreviated letter to a word

I wanted to name the the letters like PT or PIT as Pressure Transmitter or anything with P will be named as pressure and anything ending in T as transmitter. I want a cell funtion that can name all ...
3
votes
1answer
238 views

CLI program for xlxs -> csv conversion?

Is there an foss command line program that can convert between Excel (.XLXS) and Comma Separated Value (.CSV) files?
0
votes
1answer
1k views

Set row delimiter in Excel

How can I use row delimiter other than \n? CSV fields contain \n and the row delimiter is \n\n\n\n, to separate line breaks in fields from the row delimiter. I'm using Excel 2010, and in need to ...
4
votes
5answers
8k views

How can I convert a hex number to a decimal number in Excel?

I have a cell containing this value: 0x00006cd2c0306953 and I want to convert it to a number. I tried: =HEX2DEC(C8) where C8 is the cell containing my hex value. I get a #NUM error. What am I ...
0
votes
1answer
110 views

Extracting Excel-published tables from a PDF document

I'd like to copy Tables 1,2, and 3 found at the bottom of this PDF file: http://www.cbo.gov/sites/default/files/cbofiles/attachments/03-13-Coverage%20Estimates.pdf into Excel. I've tried Copy+Paste ...
0
votes
1answer
1k views

How to convert decimal years into a date (format dd-mmm-yyyy or similar) in either Excel or SPSS?

I've found a fair number of formulas online which let me convert birthdate into decimal age in years but I can't find something that converts, for instance, 1.0 into 04-Nov-2011. Any help would be ...
1
vote
1answer
538 views

How can we stop the Excel 2003 .xlsx converter from setting ownership/permissions precluding network access?

The Excel 2003 converter (to/from Office 2007 format) is changing file ownership or permissions on a Windows XP Home system when saving .xlsx files and preventing access to them from the network. We ...
2
votes
2answers
676 views

Converting “in place” a column of cells from minutes to hours and minutes in Excel

I have several columns of data in an Excel 2010 worksheet that are values in minutes and I want to convert them to hours and minutes (the data source will only generate an Excel workbook using ...
4
votes
3answers
10k views

How to batch convert .csv to .xls/xlsx

I am looking for a way to quickly convert a directory of .csv files into the .xls or .xlsx format (would be nice if I could do either/or). Is there an easy way to do this or do I need to install a ...
2
votes
1answer
812 views

Convert time to decimal equivalent it Excel / Emacs

I'm trying to create a chart of my times for my runs (e.g. 25:30, for 25 minutes and 30 seconds). How could I convert this "analog" time to the decimal equivalent (e.g. 25.5 minutes)? The problem is ...
2
votes
2answers
593 views

Convertion of excel file with point data into .cxt file

How can I convert a excel file (.xls extension) with point climatic data into .cxt file which is a free format text file. My intention is to calculate evopotranspiration using ETo software. But when ...
0
votes
1answer
721 views

How to automatically convert CSV file to XLS file with filters and formatting of the top row?

I have a big CSV file (10,000s of rows). How can I automatically convert it to an XLS file which will have Filters and some formatting (color, font) on the top row?
1
vote
3answers
761 views

How can I convert non-standard date data in Excel?

For some silly reason the data I've been provided has dates in the following format: mmddyyyy but if the date is something beginning with zero (e.g. 03132010) then it shows up without the leading ...
1
vote
2answers
1k views

Excel 2003: convert a numeric cell into time for calculations

I have some data in excel, all numeric, like: 9.00 10.35 19.10 I need to do calculations like: I got at work at 9.00, I got out at 10:00 = I've worked 1 hour How can I achieve this if all my ...
0
votes
1answer
644 views

Excel: Convert and replace time to seconds

I have a large number of cells that contain time duration in the form: 41m 9s How do I convert the duration into seconds, and then replace the old value of the cell with the converted value ? I ...
5
votes
4answers
5k views

Work with hours and minutes in Excel 2007

I'm working on a spreadsheet that holds phone calls durations. So, each call (row) has a value like 00:01:30, 01:02:12, etc. When I sum the duration column, it will give me something like 687:23:42. ...
6
votes
5answers
24k views

Change year in many date fields in excel?

So I've noticed in a worksheet I have many dates that are four years off, no doubt because of improper copy/paste from earlier question. Is there an easy way to convert a bunch of dates I select to a ...
2
votes
1answer
1k views

Best way to bring a large PDF to a readable Excel spreadsheet?

The problem here is, the database/report running software we use can not do certain things that we need (total by quarter/person/year, total for everyone for each one of those, etc.) so we have to ...
0
votes
5answers
5k views

How can I convert an ordinary text file to a .csv file, and import it to Excel?

I have a group of names and addresses that I would like to import into Outlook. At the moment I have imported them into Excel, but all names and addresses are in one long entry. All are already ...
3
votes
2answers
911 views

How to Create an XML File from an Excel File

I have an Excel spreadsheet file that has 5 or so columns and hundreds of lines. I need to convert this (export these data) to an XML file. I'm interested in three of the columns and they correspond ...
0
votes
1answer
294 views

MS Excel convert cell matrix (1x15 -> 3x5)

What is the formula for displaying cells in a 3 cell increment at a time, like A1, A4, A7, A10? Moreover, would it be possible to transform below a list (1x15) of data into a table(3x5). Thanks. ...
3
votes
1answer
3k views

Ubuntu: Convert OpenOffice Calc to Excel workbook using CLI

I need to create an automated report in a spreadsheet format. Unfortunately, There seems to be an easy way to create these reports using OpenOffice Calc, but upper managements wants them in MS Excel ...
-1
votes
3answers
899 views

Convert file for XLS to TXT format

I renamed a .xls file to .txt file but the .txt file shows like this: ...