View Single Post
  #2   Report Post  
Arvi Laanemets
 
Posts: n/a
Default

Hi

Try to type in 2005/2/29 (or whatever is the date format you use)


Arvi Laanemets


"Jo" wrote in message
...
I have the cells formated to show the dates as "2-Feb" for instance. But
when I type in 2/29, Excel converts it to "1-Feb". The only way I can bet

it
to accept 2/29 is to format the cells as text. What am I doing wrong?