Year formatting in Excel '03

  • Thread starter Thread starter gbarakos
  • Start date Start date
Format the cell as General, not yyyy

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
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-
|
|
 
Back
Top