convert

Good rainy afternoon. Perfect time for doing computer stuff. :) I export, in to excel, reports from a database. In one of my columns, (start time), the cell value displays as 0001 However, what shows in the formula bar, for that same cell, is: 7/12/2019 12:01:00 AM How do I get rid of the...

I would like to find an easy way to convert something like this (January 18 - February 2, 2019) stored in a single cell to start date and end date in separate cells. Here are a couple of examples: January 18 - February 2, 2019 February 6 - 19, 2019 Thanks

Hello All, Here is my situation, i'm using excel vba on a spreadsheet. All the values of column K are in mm/dd/yy ie (8/7/19). Now i have made a macro that take information from this sheets and fills a few word documents. My problem is that they now want the documents to display the full...

Hey, i'm trying to make a table that looks like this: <colgroup><col style="width: 25pxpx"><col><col><col><col><col><col></colgroup><thead>#DAE7F5[/URL] "] B C D E F G </thead><tbody> 17 #FFFF00[/URL] , align: right"] #FFFF00[/URL] "]0 #FFFF00[/URL] "]5 #FFFF00[/URL] "]10 #FFFF00[/URL] "]15...

So we receive hundreds of invoices from our customers every day. The invoices are in pdf format but such that you can select the text and copy and paste etc Is there a way to convert multiple pdfs of invoices into data so that I can see it Excel or Word?

Afternoon Ppl, need some help here, how do i convert eg 25122019 (ddmmyyyy) or 251219 (ddmmyy) to show its Qtr4 19 ? Any solution to this ? Much thanks.

Hi all, I'm trying to make a button click change all cell formulas on 5 different sheets to the cell values. The code I have below is perfect for the currently active sheet but I haven't had any success with specifying which sheets I want it to affect. Any help would be so greatly appreciated...

I have a list of values in the column range C32 to C800. I have a formula I use to convert a the column list to a table just 10 columns wide starting in cell L32 ... =OFFSET($C$32,COLUMNS($L$32:L32)-1+(ROWS($32:32)-1)*10,0) However, I now have a row list in the range L5:BI5, and would like...

I'm new to Power BI/Power Query and need some help. I connected Power BI to my database server and there is a field that I need to convert to date/time. The database stored the minute as the number of minutes since 24:00 on 31/12/1900. For example, 00:01 am on 01/01/1901 =1. I need to...

hi all.. how to convert number to text e.g -10% ---- to be text "negative" 50%----- to be text "positive" 0% ------ to be text "zero" i hope don't use macro is possible all number are given & random.. thanks in advance .sst

I have a userform with two textboxes that receive a number from a spreadsheet when double clicked. The numbers on the spreadsheet are percentages so I've formatted the textboxes to show the percentage. The code below works fine. I would now like to add those two textboxes together in another...

<tbody> Need to convert following cell data by either formula or clever format number custom style CURRENT DATA IMPORTED <tbody> START FINISH hh/mm Mon Jan 08 02:20:13 AEST 2018 Mon Mar 08 09:40:17 AEST 2018 ?? imported as text, cant format number to date/time imported as text, cant...

I'm having an issue and I think part of it is I'm probably overthinking the issue. I have an output report that provides me with some folder sizes. It came out in megabytes. As I'm presenting this to upper management, I need it in a format they understand; gigabytes. How can I take column "C"...

How do you convert 01241 to 1:24 am - hh:mm 1 for am 2 for pm 01241 (hhmm#) to 1:24 am - hh:mm 1 for am 2 for pm 02452 (hhmm#) to 2:45 pm - hh:mm 1 for am 2 for pm 12142 (hhmm#) to 12:14 pm - hh:mm 1 for am 2 for pm 08451 (hhmm#) to 8:45 am - hh:mm 1 for am 2 for pm I want to have data entry...

Hi, What formula is best to convert an American date to Uk date? ie 8/13/2019 to 13/08/2019 8/7/2018 to 07/08/2018 thank you

Anyone know how to convert Excel's 'ERF' function into a MySQL Function? Any help would be much appreciated. Apologizes in advance if this is a the wrong forum. In a jam and need some help! Thank you!!!

This was recorded Sheets("Sheet1").Select Cells.Select Selection.Clear Range("A1").Select With ActiveWindow .SplitColumn = 0 .SplitRow = 1 End With ActiveWindow.FreezePanes = True Columns("A:A").ColumnWidth = 36 Columns("B:B").ColumnWidth = 36 Is...

Hi, i have the following which loads a webpage and extracts the JSON Sub JSON1() Dim username As String, password As String username = "xxx" password = "xxx" Dim xmlhttp As Object, myurl As String Set xmlhttp = CreateObject("MSXML2.serverXMLHTTP") myurl = Range("C1")...

Hi folks I understand there are several forums on this or similar but I am having a nightmare with it. I have values displayed in decimal feet which I have converted to metres with no issues, but I now have to display this in inches and fractions as well as feet, inches and fractions. I have...

Hi guys, as I am importing an Excel Worksheet into my access database I need some assistance to convert a column in Excel to a longInteger Field in Access. Sub FillAllCellsWithLongInteger() Dim Zeile As Integer Dim ZeileMax As Long Application.ScreenUpdating = False With...