P
Pat Mooney
I have 2 columns labeled Date and Time. I used the format
mm/dd/yyyy and found that 3/14 gives me 03/14/2003. So
far so good. But I want excel to enter the slashes for
me. I suspect a custom format would do this, but Excel is
not very specific as to how to set one up. Similarly, for
times. I want them on a 24-hr clock and found a format
for this but whwn I enter a time all I get is "00:00" [to
say nothing of a date in the formula bar which is a) not
the correct date; and b) not needed in the timee column
anyway]. I assume this has something to do with Excel
assuming I want to calculate with these values, but in
this casse I do not. And, as with dates, I don't want to
type the colon, either). Can someone help me?
mm/dd/yyyy and found that 3/14 gives me 03/14/2003. So
far so good. But I want excel to enter the slashes for
me. I suspect a custom format would do this, but Excel is
not very specific as to how to set one up. Similarly, for
times. I want them on a 24-hr clock and found a format
for this but whwn I enter a time all I get is "00:00" [to
say nothing of a date in the formula bar which is a) not
the correct date; and b) not needed in the timee column
anyway]. I assume this has something to do with Excel
assuming I want to calculate with these values, but in
this casse I do not. And, as with dates, I don't want to
type the colon, either). Can someone help me?