MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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?

Karen C.

Posted by Mark w. on February 15, 2002 7:16 AM

1. You'll have to covert MMDDYY values to MM/DD/YY
after you enter them. Follow the instructions at

2. Don't skip rows...instead increase the height
of your rows to add "white space". Your worksheet
will also be smaller and take less memory.

Posted by Karen on February 16, 2002 8:48 AM

I'm new to this, so forgive me if I'm not following proper procedure. This is to thank Mark w for his help with the date formula problem I was having. I really appreciate it.

Thanks Mark,