convert

I use following formula to convert Time to numbers, but for some reason VBA converting some cells to column name ( column name is HOUR ) Can anyone tell me what is problem? Sub Convert() With Worksheets("DATA").Columns(10) .NumberFormat = "0" .Value = .Value End With End Sub

I have exported a card database(600 cards) into excel from a security system to upgrade to a newer card reader system. However, the proper and new card reader system reads the card data in reverse. So I have dumped the data in an excel spreadsheet to sort the data around and import to new...

I need to subtract hours from a date/time value using a formula. The results I have tried dont seem to work. What i've tried: Using a formula in B2 like =A2-4/24 to reduce 4 hours doesn't work. It returns #VALUE ! I have also tried =DATEVALUE(A2) and it returns #VALUE ! I have also tried to...

Hello. In column A (A1:A600) I have dates and time in format dd.mm.yyyy - hh:mm (ex. 04.10.2019 - 20:00 , there is one space between dd.mm.yyyy and '-' and one space between '-' and hh:mm). All those cells in column A are text cells. I need formula to convert those "dates" into weekday name...

Hi, I'm trying to convert the following string (135087E67) to text but excel keeps returning me scientific notation instead. All I get is 1.35087E+72. How can I force Excel to convert it as text and keep it as 135087E67 and not convert it to scientific notation once I create a .csv file from...

Hi, Im trying to create a script to change all the values on the press of a button from GBP to EUR and back if the button is presed again, can anyone help. I search online and the forum but not joy. Many thanks

I have an extract of data where the duration for an activity is listed as ## hour ## Minutes ## Seconds ex. 1 hour 22 minutes 29 seconds. Is there a way to convert this a time format so I can perform date math between two activities? Not all entries have hour, minutes and seconds. There are...

Hi, In a database our timevalues are stored like 94500 = 09:45:00 121755 = 12:17:55 58 = 00:00:58 What is the best way to convert these when pulling them via ODBC? Ideally in the SQL query but power query is an option also. Thanks

Hi I need a vba code that converts a decimal input to real time and does nothing if it's time. for example: 2.5 convert to 2:30 3.5 convert to 3:30 and if input is time do notting 2:30 convert to 2:30 3:30 convert to 3:30 . . .

Hello Message Board: I am trying to convert a small data set from text to number ( AMOUNT Column) . I have tried several methods including text to columns , Fomulas like =VALUE(TRIM(a3)), Trim, etc and I cannot get rid of the trailing spaces to the right. I need a formula solution for this. I...

I am trying to convert an excel formula in access but don't have the knowledge to do so. Is there a way to convert this excel formula to run with my access query? This is what I am using in Excel. =IF(S2<1825,"< 5 Years Old",IF(AND(S2>1824),"> 5 Tears Old")). The Access database name is...

I am trying to convert this report number to a date and time, is there a single formula that can achieve this or do I need extract the numbers using left/right formula? W3_20190903_230338 = Sept.3,2019, 11:03:38 pm

How to convert 13:10 (13 hrs. 10 mins) into 13.7 (number)?

I am using vba code to populate the body of an email. In this line [& "Invoicing with Mercury - https://vimeo.com/274171345 " & vbLf _] How do I convert this [https://vimeo.com/27417145] into a url [link]?

Hi there, I am completely new to excel and I was unaware of the extent of its functions. I have been tasked with converting the layout of a cinema timetable that is in a spreadsheet. the timetable also includes the age rating of the movie and the director . I am also not going to include certain...

Hi, I have a worksheet where the data has come from an external database...The numbers have come through as text... e.g. '$123,444 How can I convert these to numbers...I've tried using formatting and that doesn't work. Thank you

Trying to convert a DAX Calculated Column to a Measure with no luck. Any ideas? See below and attached. Thanks. =CALCULATE ( DISTINCTCOUNT ( Table1[Patient ID] ), FILTER ( Table1, Table1[TotalTime] > Legend[Start] && Table1[TotalTime] <= Legend[End] ) )...

im trying to create a code to get the weekending date. However, there is an error when i try to run it. =A1+(7-WEEKDAY(A1)) - this is the code i'd like to convert to vba WE.Value = transdate.Value + (8 - Weekday(transdate.Value)) -----****Note WE.value is a textbox where the weekending date...

I have text in cells: A1 2.11667e-03 A2 2.01168e+02 A3 2.54e-02 I would cells B1,B2, and B3 to convert these text cells to their proper scientific notation. I would also like cells C1,C2, and C3 to convert these scientific notation numbers to their decimal equivalent. What...

Hi, I am attempting to automate some data entry in Excel. I have a workbook, and each sheet's name is a 6-digit date. I want to create a formula to add that sheet's name to a specific cell, but in a standard date format (m/dd/yyyy). For example, a sheet is named 083019. I want cell D2 to...