Thanks JE

Matt

JE McGimpsey wrote:
XL's input parser doesn't pay attention to the format of the cell
(except if it's Text, in which case it doesn't parse the entry at all)).

Take a look he

http://cpearson.com/excel/DateTimeEntry.htm

Can someone tell me how to write a custom format code for Date Formatting.
I've seen this several years back and I don't remember the code which is
[quoted text clipped - 7 lines]

Matt

--
Please take a look at www.openoursite.com Click on: "Keywords" and then
Click on "Matt's Story" and if you are a man, you should be very happy that
you read my story. God Bless for everyones help.

Message posted via http://www.officekb.com