1. Z

    Convert Longitude & Latitude Start and End Coordinates into Nautical Miles (no API)

    I am trying to convert the START and END latitude and longitude coordinates I have into nautical miles. I read here that I had to convert my latitude and longitude (in degrees) to radians which I did by using the =RADIANS function. My situation is as follows: I have a start and finish lat and...
  2. J

    Macro conversion help needed (2013 to 365)

    Hi i have an macro that saves a pdf and then emails out statements. But on conversion from 2013 to 365 it no longer works. Could anyone have a look over the code and see if they can see what the issue is i.e. whats changed between versions that i need to update? Any help appreciated. Sub...
  3. H

    Calculating The Impact of Volume and Conversion Rate Changes

    Hello everyone, I'm trying to calculate the impact three ever changing variables are having on our month on month performance. We have 10 buckets that are filled with applications and the scenario is: The total number of applications changes month on month The % of total applications that sit...
  4. R

    Conversion of column list to comma delimited string

    Is there a macro I can use that would convert this... <tbody> USA Germany Chile France Turkey Indonesia </tbody> to this.... USA,Germany,Chile,France,Turkey,Indonesia The column will have always data in Column A and rows could vary in terms of data input.
  5. R

    PDF to Excel conversion through VBA

    Hi All, Can anyone suggest if PDF to excel conversion is possible through VBA. I search many websites about that but got no solution. Please note my PDF can be multiple pages.
  6. V

    Automatic conversion of the currency

    Hello! I have a table to be filled in with the prices of some products from different offers. Some products are acquired in the Euro currency and the others in the RON currency. My question is if is any possibility (macros, formulas) so that when I insert the value expressed in one currency...
  7. J

    Batch conversion for coordinates - Northings and eastings to OS grid

    Hi Everyone, Has anyone got/seen/aware of a batch conversion tool that I can use to get the 10km OS Grid ref from a list of Northings and easting? I've a list that's 3,000 long so can't contemplate doing them manually/singularly using the tools I can see online and don't know where to start to...
  8. P

    CSV data conversion

    Hello there, Since I installed office 2019 Excel I got data conversion problem when opening a CSV file. problem : when opening a genuine csv file form bank or postal account some lines show data on conol B or C So if a run data conversion I got a message telling that this action will...
  9. K

    Conversion to MD5 format

    Hi, Can you help me on how to convert string in excel to MD5 Format. Regards, Kissy
  10. J

    Importing Excel Spreadsheet Automatically Without Conversion Error

    Hello, I'm trying to setup a macro that will allow me to upload a spreadsheet "ABC.xlsx" each time I run it; however, I keep getting a conversion error. The reason appears to be some data is not yet populated (blanks). Is there a way to import the data so everything is short text so everything...
  11. R

    Converting dates to standard format

    <colgroup><col style="width:48pt" width="64"> </colgroup><tbody> 26.05.18 10.05.18 19.04.18 I'm importing dates that look like this. I'm trying to get - 26/05/18 or 26/5/18 or 26/05/2018 or 26/5/2018 Any of these will do...
  12. P

    Complex Sumproduct Formula Not Translating to Google Sheets

    I'm trying to convert a model that has a complex sumproduct formula: "=SUMPRODUCT($AX14:CB14,N(OFFSET($BX$4:DB$4,0,COLUMN(DB$4)-COLUMN($BX$4:DB$4))))" And once the column count gets to 31 (range of AX->CB...BX->DB), I get the following error: "SUMPRODUCT has mismatched range sizes. Expected...
  13. R

    Converting fractions to decimals

    I have data which looks like this - 9/4 JF 6/4 F 5/2 F 2/1 F etc etc Using this formula I can convert these to - 9/4 6/4 5/2 2/1 ' =IFERROR(LEFT(T136,FIND("/",T136)+1),T136) But what I'm really looking for is - 2.25 1.5 2.5 2 I'm happy to use an extra column to achieve my goal but if it can...
  14. B

    month/date 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
  15. M

    Convert a Shape to a Command Button

    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...
  16. L

    conversion module

    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...
  17. A

    Power Query added column - Value.Divide(Value.Add( )) returns all null values

    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...
  18. J

    Difficulty with lookup tables - Binary/Hex

    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...
  19. S


    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...
  20. N

    Currency Conversion

    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...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back