Display Year format as 'yy

[noviceoffice]

How do I display (and not calculate) year as 'yy for the 1900 - 200
range

 

[Frank Kabel]

Hi
wh not format the cell with the custom format
YY

 

[noviceoffice]

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

 

[Ron Rosenfeld]

How do I display (and not calculate) year as 'yy for the 1900 - 2004
range?

Format/Cells/Custom Type: \'yy


--ron

 

[Frank Kabel]

Hi
try the custom format
"'"YY

 

[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??

 

[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!

 

[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)

 

[Peter Atherton]

-----Original Message-----
How do I display (and not calculate) year as 'yy for the 1900 - 2004
range?

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
(e-mail address removed)

 

[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???

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

 

[noviceoffice]

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

 

[noviceoffice]

Thank you Ron!

*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 *