in Education by
I have an excel workbook that has more than 20 pages, each has a plenty amount of data. Every time I close the workbook, and then open it, I find all cell's types to be set to dates, which causes all formats to be repeated (that's 2 hours of work!!). Any idea why this is happening and how to avoid it? JavaScript questions and answers, JavaScript questions pdf, JavaScript question bank, JavaScript questions and answers pdf, mcq on JavaScript pdf, JavaScript questions and solutions, JavaScript mcq Test , Interview JavaScript questions, JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)

1 Answer

0 votes
by
Change the format of the cells and double click in one of the cells. Repeat this in all sheets. Open and close excel file and see whether the cells double clicked retains the format that you gave.

Related questions

0 votes
    write about cancel,enter and insert function button in ms excel 2010 Select the correct answer from above options...
asked Dec 10, 2021 in Education by JackTerrance
0 votes
    Numbers entered in MS Excel 2010 could be a value __________ Select the correct answer from above options...
asked Dec 25, 2021 in Education by JackTerrance
0 votes
    In Excel, which function returns the total of the range values? * O ADD() O &() O SUMC) Select the correct answer from above options...
asked Dec 31, 2021 in Education by JackTerrance
0 votes
    In LISP, the function returns t if is a CONS cell and nil otherwise __________ (a) (cons ) (b) (consp ) (c) (eq ) (d) (cous = ) Please answer the above question....
asked Oct 22, 2022 in Education by JackTerrance
0 votes
    In LISP, the function returns t if is a CONS cell and nil otherwise ________ (a) (cons ) (b) (consp ) (c) (eq ) (d) (cous =) Please answer the above question....
asked Oct 9, 2022 in Education by JackTerrance
0 votes
    In LISP, the function returns t if is a CONS cell and nil otherwise __________ (a) (cons ) (b) (consp ) (c) (eq ) (d) (cous = ) Please answer the above question....
asked Oct 2, 2022 in Education by JackTerrance
0 votes
    In LISP, the function returns t if is a CONS cell and nil otherwise ________ (a) (cons ) (b) (consp ) (c) (eq ) (d) (cous =) Please answer the above question....
asked Oct 2, 2022 in Education by JackTerrance
0 votes
    In LISP, the function returns t if is a CONS cell and nil otherwise ________ (a) (cons ) (b) (consp ) (c) (eq ) (d) (cous =) Please answer the above question....
asked Sep 23, 2022 in Education by JackTerrance
0 votes
    How to read an excel sheet and put the cell value within different text fields through UiPath? I have a excel ... help me out please? Select the correct answer from above options...
asked Feb 8, 2022 in Education by JackTerrance
0 votes
    c. To copy a formula in Microsoft Excel, you select the cell and drag this symbol that appears on the lower ... 7 computer please help Select the correct answer from above options...
asked Dec 28, 2021 in Education by JackTerrance
0 votes
    To copy a formula in Microsoft Excel, you select the cell and drag this ___ write one word Select the correct answer from above options...
asked Dec 27, 2021 in Education by JackTerrance
0 votes
    To copy a formula in Microsoft Excel, you select the cell and drag this ___ write one word Select the correct answer from above options...
asked Dec 26, 2021 in Education by JackTerrance
0 votes
    I'm using VB code created by L42 on 4/27/14 that creates a checkbox list in a single cell. ... , JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Jul 11, 2022 in Education by JackTerrance
0 votes
    I have encountered a problem during my work. There are over one hundred worksheets in my excel, and I ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked May 7, 2022 in Education by JackTerrance
...