convert number

  1. E

    Convert number into hours in minutes

    example In Time 8:00 AM --A Out Time 3:00 PM --B formula 24*-(A-B) Answer 7.00 how do I convert this number into hours and minutes.
  2. T

    Convert number to Characters

    Hi. I want to make a counter that counts from 0 to 456.976 (26 * 26 * 26 * 26) I have made the first tasks in VBS. The number is stored in a textfile. I load the number and place it in a document. Add one to the number and save it to a textfile. No problem. The problem is converting the number...
  3. B

    vba- round then convert number

    Hey, the below code uses Solver determine to determine what a number needs to be in order to make 20%. It works well, however after the macro run I need it to round to the nearest whole number then convert it to end in 990. Example. From 154,859.054548 To 154,990 Sub MultiSolve()...
  4. U

    Convert 215 to 2:15

    When I export data from Google Analytics into Excel , the minutes and seconds are converted into a number, .e.g 2:15 > 215. How do I convert the number back to minutes and seconds or simply insert a colon? I manually changed 215 to 135 seconds, divided by 60 and formatted the cell but that seems...
  5. S

    Need to Expand a Macro...if possible

    I am using Excel 2007. With the help of this forum, I have the following code in a worksheet VB so that anytime I type a number in a column, it shows up as a negative value. Private Sub Worksheet_Change(ByVal Target As Range) Dim cel As Range If Intersect(Target, Range("I:J")) Is Nothing Then...
  6. babyhime4

    Convert Number to Text

    How can I format a column of numbers as text other than: 1. Format Cells... select "Text" on the number tab 2. Create a column with the apostrophe, and use CONCATENATE function 3. Use TEXT function or any other type of function 4. Macros Is there a fast and simple way to do this if I need to...

Watch MrExcel Video

This Week's Hot Topics

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 MrExcel.com.
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 "mrexcel.com".
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
Top