conversion

Hello Everyone, Could you please help me find another solution with the following: I have sums of Bytes that exceeds many gigabytes in a Pivot Table. I would like to "format" these long numbers in terabytes or, at least, in gigabytes So far, the only way I've found is by adding a calculated...

Hello I need some help with either a formula or VBA macro to solve a conversion issue in a packaging table for tile. (Sample below) The challenge ahead of me is to convert all sales data to the same unit of measure so I can rank the number of pieces sold. the issue that makes this complicated...

I have an Excel xlsx workbook generated by a export from a IT system. I'm trying to leveraging Excels awesome Query language feature do some ETL operations before the data will be sent on to another system. TL;DR I'm stumbling on an issue that my source data is interpreted as numeric data when...

Hello All, I am not able to add a percentage column in a pivot table. My data looks like this: Name Location Call Date Subscription Date State Country John Hackensack 4/4/2017 4/29/2017 NJ USA Peter Fort Colins 4/7/2017...

I do a daily process that requires me to take foreign currency values and convert them into US dollars (USD). For example A1 has the amount of .38 and B1 would have CAD (Canadian Dollar). I then would go to the website XE.com for the conversion rate, search for CAD converted into USD. Take that...

Hi, I am using MS Excel - 2007. I've to convert Excel file to DBF file. How to do this? Can any one please help?

I've been trying to convert several excel tables to .csv format for use in a GIS program. Each time I do this, certain cells in essential column (which is used to join the .csv table to spatial data) get corrupted. The column contains UIDs that are numerical. The corruption places either a ? or...

Hi, Is there any way we can directly pull the latest currencies from a website every time we select a certain currency from a drop down list? Eg. I want to convert a list of rates from USD to NOK. So I have a drop down cell, A2 - "USD" and "Convert to" drop down list in cell B2 - "NOK" and...

I need a formula to convert hours minutes & seconds into total minutes. h m s total minutes Example: 3:04:27 would display 184.27

Hi team and good morning! I´ve been looking around to see if I found this kind of thread somewhere, but I can only find the viceversa (from txt to Excel). I basically want to convert an Excel worksheet to a txt file with a pipe delimiter (|) to separate the columns. My Input - Excel sheet -...

Hello all, I hope you are well and would like to thank you for the 1000 of times MrExcel has saved me. If someone knows a macro that could convert some horizontal data I have into vertical data it would save me hours of manual work. Unfortunately, I'm pretty new to creating Macros and have...

Dear All, I have a database of equipment in excell. One of the column has hyperlinks to websites of specific equipment. The hyperlink is given as "View details". I need to transform it into a simple URL like http:....etc. Kind regards MD

Hello, I'm building an electricity/utilities monitoring scorecard for a Chinese factory. We want to take a daily electricity meter reading, run formulas to determine the amount of Chinese Renminbi due on the bill, and convert the Renminbi to USD. This scorecard will keep a running tally with...

My formulas keep converting to values after saving and closing a spreadsheet, then reopening them. Is there an setting I need to change? Thanks.

Hello All: I have a spreadsheet that performs countif functions in cells D4 to D46 (data on another tab). Cell D1 contains a date. I need some VBA code that will convert the countif results (cells D4 to D46) to values and to do this on the date contained in cell D1. I need to perform this...

I have an excel spreadsheet with over 22,000 rows. Each row describes where a deer with a GPS collar was standing at a given time. I need to convert the time data, which is in Zulu, to time data that I can use arithmetically. I'm not sure what this unit is called, but seconds since Jan 1st 1900...

Hello Everyone, I am converting 500 text files to CSV files by just changing the extension from .txt to .csv. The problem is, the the data in the text file is splitted into multiple columns of the first row of csv file. My objective is, when I convert the text file, then all...

I vaguely recall that there is a way to convert a range of cell references to absolute cell references in an efficient manner, but I have forgotten how. Basically the problem is that I wish to copy a range of cells with standard cell referencing to another column next to the original column and...

Hello, The company I work for goes by the 4-4-5 Financial Calendar. I found a formula that will Convert a DATE to the MONTH of 4-4-5 =MATCH(A1-DATE(YEAR(A1),1,0),{0,29,57,92,120,148,183,211,239,274,302,330}) A1 Being a DATE example: 1/31/2013 B2 Results in Displaying the 4-4-5 MONTH: 2 Can...

I have been attempting to convert numbers such as '080952' to 08:09:52 am. I have tried time conversion by formatting cells, and when I do I receive 0 or 12:00am. I have used the following formula: =TIME(VALUE(LEFT(B2,2)),VALUE(MID(B2,3,2)),VALUE(RIGHT(B2,2))) and it works well for the most...