Change Data in Excel Cells

[lisamarieb07]

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 entered times in the cells, but you only see the time when you click on each individual cell. How do I get rid of that? I want 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!!!

[BradDet]

Insert a new column to the left (or right) of your dates
in that new column use the TRUNC function to remove the time

For example if your date/times are in A1, then in B1 put =TRUNC(A1)

Copy that forumla all the way down that row

Hightlight the new column you just made with all the forumlas

Choose Edit..Copy

Insert a new column (eg: 'C')
Move to the first cell in the new column

Choose Edit..Paste Special
Under the Paste Special Options choose 'Values' (The default says 'all')
Hit okay.

Format the new Column 'C' as type Format Cells (Date)

If it worked correctly you will now have 3 columns

First column is the orginal column and contains the dates and the times
Second column is the column with all the formulas
Third column contains dates without any times

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.