Prev: Filter with criteria!
Next: Unpivoting a worksheet
From: scootr on 19 Apr 2010 12:07
Thanks for all of your help guys.
I found a simple solution.

I just formatted the cells as TEXT.
Everything appears to be working exactly as I want.

Again,
Thanks for your help.

"Dave Peterson" wrote:

> You could use a macro. But I wouldn't. I'd be worried that a number that I
> wanted would be converted to a date.
>
> You could use two cells (or two columns of cells???) with a formula in the
> second column that uses the first cell to create the real date.
>
> So if you enter 15 in A1, you could use this in B1:
> =date(year(today()),month(today()),a1)
> or maybe better:
> =if(a1="","",date(year(today()),month(today()),a1))
>
> But you'll have to make sure you enter a valid day for the current month.
>
> scootr wrote:
> >
> > If I format a cell as a date mm/dd/yy; If I only type in the month and date,
> > "4/15" ,excel will automatically fill in the the current year, so the cell
> > will end up displaying 4/15/10.
> >
> > But if I only type in the date, "15", then excel will fill in the January
> > 2000 as the default month and year, so the cell will end up displaying
> > 1/15/00.
> >
> > Is there a way to tell excel to auto fill in the current month and current
> > year when I do this? (example: If I type in the date, "15", then I want excel
> > to fill in today's month and year, so the cell will display 4/15/10.)
>
> --
>
> Dave Peterson
> .
>
First  |  Prev  | 
Pages: 1 2
Prev: Filter with criteria!
Next: Unpivoting a worksheet