If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Cannot get date to format correctly
I have a problem. I keep trying to format the date in certain cells, and it
keeps wanting to add the time. The date is pasted in from worksheets where I had used a NOW() formula, but I had just pasted in as values to the new worksheet. No matter what I've tried as far as changing the format, it just keeps showing the time. How can I keep the date, but get it to stop showing time? |
#2
|
|||
|
|||
Cannot get date to format correctly
If I read it right, you just need to format the cells
Right click, select format cells, General Tab, Custom (bottom of the list) and if not already provided, type in the format you want eg. dd/mm/yy - 25/05/10 mm/yyyy - 05/2010 mmm/yyyyy - May/2010 and so on. If this helps, please click yes "jknapp1005" wrote: I have a problem. I keep trying to format the date in certain cells, and it keeps wanting to add the time. The date is pasted in from worksheets where I had used a NOW() formula, but I had just pasted in as values to the new worksheet. No matter what I've tried as far as changing the format, it just keeps showing the time. How can I keep the date, but get it to stop showing time? |
Thread Tools | |
Display Modes | |
|
|