converts

I have a column of dates and times downloaded from a CSV file formatted as text as: 2019-10-10T08:30:47+00:00 Please could you generate a formula that converts the first part into: 10/10/19? Many thanks HT

I have an file in csv format that has a field with page ranges in it such "3-4" or "6-10". When you open this into Excel, it converts it to a date. Once converted, I can't get it back to text. Any workaround?

Hi guys, I have a CSV exporter which converts a PDF into excel where the PDF file has customer details like Name, Guardian name, House no, Gender etc., Now the problem is whenever i use the CSV exporter the zero in house no removes automatically For example: Actual data of House no in PDF...

I'm likely having a major brain fart here - this seems so easy, but I have never seen this happen before. I have a column where I am inserting due dates. The entire column is formatted for mm/dd/yy;@ I have used this spreadsheet for years. However, all of a sudden when I enter a date, it...

I have a list of times in minutes and want to convert to HR:Min:Secs but only the 4th in the list converts correctly. I am using custom format > hr:min:secs, no formula as such. thank you. here is the list in mins >> converts to..... <colgroup><col><col></colgroup><tbody> 99.7885835 >>...

Hi, I'm hoping someone can help me, I'm trying to import some data to one of our systems in a csv(Comma delimited (*.csv) file. I have a column containing ID numbers (must read this) column below, when i save the file the number string changes to the following (Converts to this) column below...

Hi, is there a way to input time as 1700 or 2100 or 1700 or 0700 and excel auto convert it as 5:00 PM, 9:00 PM, 7:00 AM on the same cell. or input as 17.30 and it converts it to 5:00 PM

I've worked for converting figures to words in the following manner and differently only after decimal from the link with my previous thread 1031511-converting-figures-words-seems-correction-required I get following results When entered 0.25 the Mid$(Paisa$,1,2) of Text = 25 LeftDigit$ =...

Excel 2007 Textbox changes LinkedCell Cell format to Text. If I do a VLOOKUP on that cell it fails and I have to "Convert to number". My application is to enter a ZIPCODE into ZIP textbox, then for CITY and STATE to autofill using VLOOKUP in both CITY and STATE cells.

Good Day, I want to convert my text in cell A1 and it contains 9-16-32 and I would like to make a formula that the result would be in Cell A2 is (9º 16.32‘N) I wonder if it's possible. If it's possible I will be gladly appreciate your help. Thanks & God Bless