1.

Solve : Change Data in Excel Cells?

Answer» <html><body><p>Ok...I will try to explain this as well as I can...I have a spreadsheet that has columns with dates in them. When you look at the spreadsheet, all you see is the date. However, the person who created the spreadsheet also <a href="https://interviewquestions.tuteehub.com/tag/entered-2072095" style="font-weight:bold;" target="_blank" title="Click to know more about ENTERED">ENTERED</a> <a href="https://interviewquestions.tuteehub.com/tag/times-344892" style="font-weight:bold;" target="_blank" title="Click to know more about TIMES">TIMES</a> in the cells, but you only see the time when you <a href="https://interviewquestions.tuteehub.com/tag/click-918865" style="font-weight:bold;" target="_blank" title="Click to know more about CLICK">CLICK</a> on each individual cell. How do I get rid of that? I <a href="https://interviewquestions.tuteehub.com/tag/want-1448756" style="font-weight:bold;" target="_blank" title="Click to know more about WANT">WANT</a> to see only the date when I look at the spreadsheet AND when I click on each individual cell. My format for these cells is the first option under FORMAT CELLS, NUMBER (tab), DATE. PLEASE HELP!!!Insert a new column to the left (or right) of your dates<br/>in that new column use the TRUNC function to remove the time<br/><br/>For example if your date/times are in A1, then in B1 put =TRUNC(A1)<br/><br/>Copy that forumla all the way down that row<br/><br/>Hightlight the new column you just made with all the forumlas<br/><br/>Choose Edit..Copy<br/><br/>Insert a new column (eg: 'C')<br/>Move to the first cell in the new column<br/><br/>Choose Edit..Paste Special<br/>Under the Paste Special Options choose 'Values' (The default <a href="https://interviewquestions.tuteehub.com/tag/says-1195457" style="font-weight:bold;" target="_blank" title="Click to know more about SAYS">SAYS</a> 'all')<br/>Hit okay.<br/><br/>Format the new Column 'C' as type Format Cells (Date)<br/><br/>If it worked correctly you will now have 3 columns<br/><br/>First column is the orginal column and contains the dates and the times<br/>Second column is the column with all the formulas<br/>Third column contains dates without any times<br/><br/>If desired delete the first and second columns, note that once deleted, you will be unable to see the times anymore in that file, as you have removed the time portion of the data from the file permenantly.<br/></p></body></html>


Discussion

No Comment Found

Related InterviewSolutions