is there a way to copy the function = NOW() and paste as static date/time using the function if (true response) =

Office

Question:This is the current aguement = if (J14 > 0,$ F$ 3, "") where F3 = NOW(), problem I have, is when it is glued to the time automatic updatesAnswer:HelloSay that you want the Date-time in the cells: K14, K15, K16,... ect,.If J14, J15, J16... > 0try this code, without the use of formula...(1) Click the right button on the sheet tab, select view codeand paste in the following:[Edit 17: 20...Read More

Posted: 23 Mar 2012

Tags: is there a way to copy the function NOW and paste as static datetime using the function if true response there way copy the function NOW and paste static datetime using true response

I have an excel file (10) with a column of date in format yyyy-mm-dd hh: mm: ss. I want to convert to the standard date/time format - that is mm-dd-yy hh: mm: ss.

Office

Question:Downloads have the system date is 2012-mm-dd hh: mm: ss General format. I need to convert to the format of date normal mm-dd-yy hh: mm: ss.Thank youAnswer:Select your cells and run this small macro:Sub ReFormat()Dim r As Range, v As StringFor each r in selectionv = r.Textyear = Left (v, 4)MN = Mid (v, 6, 2)dy = Mid (v, 9, 2)HR = Mid (v, 12, 2)Mint = Mid (v, 15, 2)SC = Right (v, 2)r.NumberFormat...Read More

Posted: 19 Feb 2012

Tags: I have an excel file 10 with a column of date in format yyyymmdd hh mm ss I want to convert to the standard datetime format that is mmddyy hh mm ss have excel file with column date format yyyymmdd want convert the standard datetime that mmddyy