Navigation section

formulas

  1. Curious

    Windows 11 Excel 365

    A question: I have a cell in excel with date format DD-MM-YYYY. This cell has a date for example 19-4-2023. I have another cell with the format YYYY-MM-DD How can I automatically convert the date 19-4-2023 to 2023-4-19? Thanks José Paiva
    • Curious
    • Thread
    • automation data formatting date conversion date format dd-mm-yyyy excel 365 excel tips formulas spreadsheet yyyy-mm-dd
    • Replies: 2
    • Forum: Windows Help and Support
  2. L

    Windows 10 Excel help

    Hello all. I have no programing knowledge at all. Yea, i have taken a single intro class to java but that dos not go well and that was years ago. First, ill explain what o do have and it works. In excel, i jave in column A1:A95 names of common materials such as aisi 1020 steel, alm 7025 t6...
    • LT72884
    • Thread
    • automation calculations common materials data entry data validation density dropdown excel formulas help introductory mass materials programming sheet tapatalk user input user interface volume
    • Replies: 21
    • Forum: Programming and Scripting
  3. K

    Windows 7 How to add new sheet and retain formulas

    I have a combination Check Register/Expenses Excel 2010 Workbook. I would like to add a new Sheet (for 2013) which retains formulas, but has no content. How do I do this? I tried just copying 2012 into a new sheet for 2013, but when I try to delete the content, all the formulas also disappear...
    • kevphil
    • Thread
    • check register content management data retention excel 2010 expenses formulas sheet workbook
    • Replies: 3
    • Forum: Windows Software
  4. C

    Windows 7 Excel 2010 Errors

    We work for ITO-Client-Management team. There are some issues while using the MS-Excel 2010 which we work on daily basis. File size is 12.5MB and has 42600 plus rows and 17 columns. 1st ISSUE: When a formula (i.e.: COUNTIF, VLOOKUP) is run, it takes lot of time (30min) for compilation. The...
    • chshakerwin7
    • Thread
    • client management copy countif ctrl d document not saved errors excel 2010 excel issues file size fill down formulas hanging it support move performance slow software problems task manager vlookup worksheet
    • Replies: 1
    • Forum: Windows Upgrade and Installation
Back
Top