Home |
Search |
Today's Posts |
#1
|
|||
|
|||
***DATE HELP***
Two queries:
1. have a cell in format of dd/mm/yyyyy hh:ss. Need to dump into a new cell, just the dd/mm/yyyy portion so that I can perform further calculations. Everything I try displays just the dd/mm/yyyy data, but when the cell is seleced, the hh:mm is still there. 2. Same situation when using the month function on a date. The function output cell does indeed display the month, but the actual data in the cell is still the date. Have tried trimming, pasting values only and a whole bunch of other issues. HELP!!!! |
#2
|
|||
|
|||
1. =INT(A1) and form at as date
2. and the question is? If you just want a month, try =TEXT(A1,"mmmm") -- HTH RP (remove nothere from the email address if mailing direct) "Andy" wrote in message ... Two queries: 1. have a cell in format of dd/mm/yyyyy hh:ss. Need to dump into a new cell, just the dd/mm/yyyy portion so that I can perform further calculations. Everything I try displays just the dd/mm/yyyy data, but when the cell is seleced, the hh:mm is still there. 2. Same situation when using the month function on a date. The function output cell does indeed display the month, but the actual data in the cell is still the date. Have tried trimming, pasting values only and a whole bunch of other issues. HELP!!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|