conversion

i know there are various conversion formulas available is there something i can use that for example if column A row 1 showed a date of 10/16/2018 in column B i could convert to 201810 ty

I'm sure this is an age old problem. The difference in Command Buttons and Shapes. And while you can run Macros by clicking a Shape, you can't run VBA Code by clicking on a Shape. Am I right? I've written workable VBA code for Command Buttons. They work fine. But, the look and shape of some of...

Hi The article below from Microsoft did not explain really What is Conversion? What kind of class/object etc. I used object browser and it says it is Module and it has some functions inside like Cint and Val. I understood that these functions are VBA functions. I tried them and I can access...

Hi all, When I create a calculated field in Microsoft Power Query feature ("Get and Transform" since Excel 2016) I use a combination two simple formulae: Value.Divide() and Value.Add(). For some reason, this does not work and all I get is null values. Here is the series of steps that I...

Hello all, I ave just completed converting decimal to binary without the use of DEC2BIN. However now I am moving onto converting this concatenated 8 bit binary number into Hex, without the use of BIN2HEX. What I have done so far is set up a vertical table with two columns, one with 16 values...

Hi everyone! I'm new to this forum so i'm hoping you guys can help me out. I'm trying to make a form that will be able to convert a measurement that is in carpenters form to a normal FT'In' Fraction Format. Ex. 9'6 1/2" is 09-06-08 the front 09-XX-XX stands for Ft, XX-06-XX stands for In...

Do any of you know of an Excel function or add-in that would convert currency with custom rates? I was going to make an add-in that would do the simple conversions for me but before I jump into that I was wondering if there was something already out there that accomplishes this. In case you...

Hello All, I am trying to convert information from two different systems to the same naming system so that i can compare and analyze the data. Each system has a product number and name for each item. My trouble is that the numbers and names are different between the systems. I am wondering...

Hi, I have a macro which currently allows me to select a folder contain several files, perform a task(line deletion) on all the files and save each one in turn. This works great but the file type I need to save as is a text file and currently my file type is an .spe file. I've looked at many...

won't hold in CSV format from Excel workbook. Every time I reopen the file, it converts back to mo/day/year from the year-mo-day format that I had changed it to. What Am i not doing here?

Hello, Im doing a formula for Eastern Time to Mountain time, the refernced times are just in different cells IE: B1 has ET 18:00 C1 has the conversion difference 2:00 D1 has the formula for MT: =B1-$C$1 and it works However, when I get from AM ET to PM MT I have issues. If B1 is 1am 01:00 the...

I am trying to use VBA to automatically take a cell formula and convert it to a string that can be used in VBA to place the formula in a cell. Sorry for my poor explanation. Basically I want to make a simple tool that someone could type in a formula into a cell, use VBA to convert it to a...

Can someone help me with a formula to convert units to minutes for my time card? 10 Units= 60 minutes. lets say if there are 12 units how do I convert this to the exact minutes?

Hi there, I'm considering to start working with PowerPivot but I'm concerned with the way historical data is handled. Today I use several excel files (VBA programmed) which have data and many conversion tables. They are backed-up on daily basis on my network, so if I want to see what was a year...

Hey everyone. I have a conversion table and a formula working to give me a conversion rate based on dropdown lists. This formula was always intended to work on a userform but i wanted to test my formula before trying it in the userform...

I have an xlsm spreadsheet that I created. Sometimes when I go to open the spreadsheet it will say "File Conversion In Progress" and open the spreadsheet with a different name and a .xls ending. What would cause my file to not open correctly? I've noticed this on a different file with the...

I am trying to create a Dynamic Title and coming up with errors. My field has 2 different values Conversion Install Here is my DAX Formula: Title Combined = if( ISFILTERED('Current'[Install Type]), "Selected Type is " & CONCATENATEX('Current','Current'[Install Type],", "), "Nothing Has...

So I want a formula or macro which automatically changes cell value whenever certain value is entered: Example if I enter C in A1 then cell should Automatically change to C- if I enter KW in A1 then cell should automatically change to KW so heres the conversion rule: C changes to C- W changes...

So I want a formula or macro which automatically changes cell value whenever certain value is entered: Example if I enter C in A1 then cell should Automatically change to C- if I enter KW in A1 then cell should automatically change to KW so heres the conversion rule: C changes to C- W changes...

I am seeking help on a conversion formula that would take for example "2 days 16hours" and convert it to total hours, is this possible?