I maintain my personal checkbook in an Excel (Office 2003)
spreadsheet, and (as usual) I have to add most of the entries for last
year's transactions this year (for US Income Tax preparation). One
annoying thing I face each year is that I can't use the "shorthand" date
entry: for any date this year I can omit the year, but doing that for
_last_year's_date_ fills out this year's "year" value.
Is that any way apart from changing the date on my computer to assign
last year's year for the shorthand? That is, I want to enter "5/14" and
have it expand to "05/14/2010", etc. Please advise. TIA

On Sun, 16 Jan 2011 16:22:31 -0700, Mike Copeland wrote:
>
> I maintain my personal checkbook in an Excel (Office 2003)

Please don't post the same query multiple times.



--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com
Shikata ga nai...

In article <(E-Mail Removed)>,
(E-Mail Removed) says...
> On Sun, 16 Jan 2011 16:22:31 -0700, Mike Copeland wrote:
> >
> > I maintain my personal checkbook in an Excel (Office 2003)
>
> Please don't post the same query multiple times.

My apologies. I'm new to this group, and I didn't know in which of
the Excel NGs I'd receive an answer to my query. 8<{{