Display Year format as 'yy

N

noviceoffice

It doesn't seem to work, :confused: and I need a 'yy not just yy. Any
ideas will be greatly appreciated! :)
 
N

noviceoffice

When I do that and type in 2001 so that it gets changed to '01 the cel
displays '09 (and the formula bar shows: 1909/06/24) if the 1904 dat
system is checked on. If not it displays it as '05 (and formula bar
1905/06/23). Am I doing something wrong??
 
N

noviceoffice

I tried this as well. Is there a formula or something that will exclud
dd/mm? Perhaps that will work???

Even if I don't get it to work, thanks so much for replying! :)
 
F

Frank Kabel

Hi
you always have to enter a fiull date. so in your case enter for
example
01/01/2001

If you only want to enter 2001 to create a valid date you'll need VBA
(an event procedure)
 
P

Peter Atherton

-----Original Message-----
How do I display (and not calculate) year as 'yy for the 1900 - 2004
range?
Click to expand...
Choose Format, Cell, Number, Special, and inthe format box
type yy.
1/1/1900 and 1/1/2000 will both diplay as 00

Regards
Peter
[email protected]
 
R

Ron Rosenfeld

When I do that and type in 2001 so that it gets changed to '01 the cell
displays '09 (and the formula bar shows: 1909/06/24) if the 1904 date
system is checked on. If not it displays it as '05 (and formula bar:
1905/06/23). Am I doing something wrong???
Click to expand...

I assumed you wanted to type in a date. A date consists of day, month and year
in some recognizeable (by Excel) format. Such as 1/1/01.

If you just type in a number, (for example -- 2001 --) Excel does NOT interpret
that number as a date.

If you want to type in a number, and have it display just the last two digits
of the number preceded by an apostrophe, then you will either need to use VBA,
or an adjacent column containing an appropriate formula.

Let me know.


--ron
 
N

noviceoffice

Thank you Frank! Now you know I am REALLY a novice!
Thanks so much - problem solved!
 
N

noviceoffice

Thank you Ron!

Ron said:
*On Wed, 11 Aug 2004 15:42:31 -0500, noviceoffice


I assumed you wanted to type in a date. A date consists of day,
month and year
in some recognizeable (by Excel) format. Such as 1/1/01.

If you just type in a number, (for example -- 2001 --) Excel does NOT
interpret
that number as a date.

If you want to type in a number, and have it display just the last
two digits
of the number preceded by an apostrophe, then you will either need to
use VBA,
or an adjacent column containing an appropriate formula.

Let me know.


--ron *
Click to expand...
 
Top