Year formatting in Excel '03

[gbarakos]

I have an interesting situation where a client is interested in only
entering the year in the field but the a date format. The
unfortunate year result is 1905. Even with a custom value such as
yyyy Excel still returns the 1905 "year". Now after some reading on
the google, I have found that the reason why this happens but not how
to make it work.

ref. http://groups.google.com/group/micr...read/thread/fe25baef9f57e8c7/39c5922c86bc01bf


Any ideas?

Thanks,
g-

 

[Bob Phillips]

Format the cell as General, not yyyy

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Niek Otten]

But if you want to use it in date comparisons, convert to date using the DATE() function

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Format the cell as General, not yyyy
|
| --
| HTH
|
| Bob
|
| (there's no email, no snail mail, but somewhere should be gmail in my addy)
|
| | >I have an interesting situation where a client is interested in only
| > entering the year in the field but the a date format. The
| > unfortunate year result is 1905. Even with a custom value such as
| > yyyy Excel still returns the 1905 "year". Now after some reading on
| > the google, I have found that the reason why this happens but not how
| > to make it work.
| >
| > ref.
| > http://groups.google.com/group/micr...read/thread/fe25baef9f57e8c7/39c5922c86bc01bf
| >
| >
| > Any ideas?
| >
| > Thanks,
| > g-
|
|