Date Puzzle

[rajiv_bishnoi]

I have received a worksheet, wherein there are certain dates

If i input the serial number, like 39813, it converts automatically to date 31-12-2008

however, I can not input dates like 31-12-2008 straight away ... it converts to ###########################

I tried doing cell formatting and removing any conditional formatting rules etc. However, it does not work...

any ideas?

I can mail out the sample file , if somebody can help

I believe there is some VBA code but can;t make out what from looking in developer menu... there are no modules attached to this file.

 

[Weaver]

All those hashes are what happens when you format a negative number as a date. Reformat the cells as numbers and check.

I'm guessing excel is interpreting 31-12-2008 as a sum, although I don't know whay it would do that

 

[Andrew Poulsom]

Choose Tools|Options|Transition tab and uncheck "Transition formula entry".

 

[Weaver]

Nice one, Mr Poulsom

 

[rajiv_bishnoi]

Dear Andrew, Thank you for your reply.

However, I am using Excel 2007 and can't find Tools|Options|Transition tab

 

[Andrew Poulsom]

Office Button|Excel Options.

 

[rajiv_bishnoi]

Dear Mr. Poulsom
Excellent. Many Thanks!!!