conversion

Greetings - I am attempting to convert a source TXT file to a destination CSV and have it properly formatted as it is in the destination CSV below. If you open the "Destination" text below as a csv, you can see the desired CSV format. I have an .EXE which accomplishes this in Windows XP x86...

need to convert these dates into real date - please note that the first character in the cell is a blank/space which i can trim out i believe. thanks in advance. <tbody> 18-JAN-13 01-FEB-13 15-FEB-13 08-MAR-13 05-APR-13 21-JUN-13 14-DEC-12 21-DEC-12...

For Inventory, manufacturers barcodes are being imported or scanned into Excel, problem is that Euro barcodes bring in sometimes "=" as a prefix to the numerical value skewing what Excel reads, converting the number sequence into a "formula". I want to understand and convey to Excel that it is...

I am using a date in an exported file; I want to convert it to an Excel recognizable format and basically add three quarters to it so it will reflect the quarter end date three quarters away. For example: Cell A1:20121128 I want Cell A2 to return: 09/30/2013 (Cell A1's quarter ending date...

Hi, I have a spreadsheet with numerical data in B1:B11 and textual data in C1:C11. The numerical data is a couple of digits, nothing big, and the textual data is always two letters, in this case AB, AC or AD. I have the options for AB, AC or AD for each of the cells in C1:C11 in a data...

Hello, I have problems when these example amounts/figures (in A) are shown using a 3rd party application. Instead of showing the up to two decimal places and with comma (,) if necessary, it only show the following (in B) How can I adjust in the excel in a way that i will get the correct format...

Hello! I'm new here so bare with me. I recently started working for a company that uses a production date along with the normal date system. It is easy to understand while viewing the calendar but it basically works by week numbers, starting from the beginning of the year, then the individual...

I'm having with an import that involves number that are sixteen digits long. They appear to come in from Excel in scientific notation and all I need on the Access side is a 16-character string that represents the original number. (I need it to be text because that's the way it will be stored on...

I have written the following routine that will convert the range that I've selected from Feet to MM. The problem is that I've found that there are a lot of ranges that have operators such as: <30 or 10 - 20 or >60. I need to parse this text so that the result is a string that has the same...

Okay. Here's a stumper (for me at least it is). I need to convert the following into radians: 65 feet/1 second * 12 inches/1 foot * 1 Radian/8 inches I know the answer which should be 97.5 radians. It's just getting the right formula in Excel.

I have text files that I need to modify, using formulas, in Excel 2007, and then convert back to text files. I have tried repeatedly to do this, but have found that my files, once saved and reopened, unpredictably contain cells that are surrounded by quotation marks. This does not affect all...

Word > Excel 2010 question so I have a document that lists names and addresses like this: Bob Smith 2010 Main Street BR, LA 70808 and I want to create an excel document with columns like Name, address, city, state, zip but I cant just import it into excel the way it is or it all goes into 1...

I am trying to write a loop to update files ther are numbered 1-36 but for consistency the file name always has 2 digits filename06.xlsb filename22.xlsb how do i convert the integer that increments from 1-36 to the two digit string for use in the filename refernece?

Thanks for looking at my post. I need to create a Userform that will pop up on clicking a form control button that has a text box some one can enter in a number in metric and click a button and it convert it to inches. Example: 145.6 to 5.7323 mm inch

I have some numbers in a text file, like 6-1 7-12 8-11 These denote business hours, such as 6AM to 1AM. When I do a conversion, or import into Excel, whether I import them as GENERAL or TEXT, it converts them to dates such as 1-Jun, 12-Jul, 11-Aug. How can I make them import exactly as...

I stole this from IML on June 25, 2001 11:43 AM tried to PM but I'm new so please don't harp on me too much please! Assuming your number is A1, try the following =INT(A1)&CHAR(186)&" "&INT((A1-INT(A1))*60)&CHAR(145)&" "&ROUND((((+A1-INT(A1))*60)-INT((+A1-INT(A1))*60)),2)*60&CHAR(145) The...

I am currently using Excel 2010 on Windows 7 and running a temperature/voltage/current measurement test at my work using NI test equipment that outputs data in .TDMS file format. This format can be opened using excel. I have a macro that applies a formula to all workbooks in a folder and has...

dear Mr.Excel members, could anyone kindly teach me a way, if possible bypassing serious VBA macros, : how to make EXCEL 2007 Automatically convert all my CURRENCY symbols in all cells formatted for CURRENCY in THE SAME SHEET to the one and ONLY currency selected in JUST ONE cell ? (i...

I am hoping for some assistance. I have Windows 7 Home Premium with Microsoft Office 10, using Excel 2010 v.# 14.0.4734.1000 32-bit. I have a tab delineated text document I have imported into excel. I am trying to then format the data to be imported into another program. The following is an...

I am using a series of UserForms to populate a spreadsheet with a customer's information. I'd then like to add a "Quote Number: xxxxx". Where "xxxxx" is the date/time converted to number format in order to serialize the form. The actual number of digits is not important. So something like...