abbreviating years

[Doug737]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: intel

Instead of typing the full year,i.e. 2008, I try '08 and get an error smart button. None of the options allow this result.

 

[macropod]

Hi Doug,

If you're typing a date, you can input it in DD/MM/YY or MM/DD/YY format (depending on your regional settings) and Excel will accept
it. The key is not to use the tick mark indicated in your post - just the digits and forward slash.

If, on the other hand, you're trying to input just a year, as '08, Excel interprets that as a text string instead of as a number of
any kind.

 

[Phillip Jones]

Try the following:

before typing the date click on the column, row or the cell you want to
show as Date and choose format cells
Then click date format and chose proper date format

If none there you can alter one and and save as a custom format

I've done so in 2004 and you can do it in 2008

just take one thats close and look at the formatting show in edit box.
for example there may be one that looks like mmm yyyy or mm yy

if you want to show say December 12, 2008 you would alter the above as

mmmm dd, yyyy Then save as a custom format.

then it will show up as month completely written out, day then a comma
directly beside it a space and finally the year completely given

The above is an example you can customize as needed.

After you set up the formatting as you need then entering the number
should show up as you wish.

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: intel

Instead of typing the full year,i.e. 2008, I try '08 and get an error smart button. None of the options allow this result.

--
------------------------------------------------------------------------
Phillip M. Jones, CET |LIFE MEMBER: VPEA ETA-I, NESDA, ISCET, Sterling
616 Liberty Street |Who's Who. PHONE:276-632-5045, FAX:276-632-0868
Martinsville Va 24112 |[email protected], ICQ11269732, AIM pjonescet
------------------------------------------------------------------------

If it's "fixed", don't "break it"!

mailto[email protected]

<http://www.kimbanet.com/~pjones/default.htm>
<http://www.kimbanet.com/~pjones/90th_Birthday/index.htm>
<http://www.kimbanet.com/~pjones/Fulcher/default.html>
<http://www.kimbanet.com/~pjones/Harris/default.htm>
<http://www.kimbanet.com/~pjones/Jones/default.htm>

<http://www.vpea.org>