PLEASE help with 2 questions: Date formulas / sorting data
Posted by Karen on February 15, 2002 7:04 AM
#1 - How do I keep from having to enter "/" between the month, date and year? Example: I want to enter 101102 (without having to enter slashes) and have it appear 10/11/02.
#2 - I created a check register that has 3 rows: a "To", a "For", and then a blank row for separation from the next "To", "For", blank row, and so on, for each check, deposit, etc. entered. I have columns for "Date", "Check #", "Amount", etc. I want to be able to randomly enter those dates, checks, deposits, etc. When finished, I want to sort this by date order. When I do this, though, I get all my "To" lumped together, the "For" is all lumped together, and my blank separator spaces together. Can anyone PLEASE help me?