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
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...
automation
calculations
common materials
data entry
data validation
density
dropdown
excel
formulas
help
introductory
mass
materials
programming
sheet
tapatalk
user input
user interface
volume
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...
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...