>The easiest way is enter a decimal point instead of a hyphen. Then >what I do is go to the top of the column, highlight the entire >column by clicking on the letter, then go to the tool bar and click >the "," and it will enter 2 decimal places by default for the day >part of the date. This allows easy data sorting from the toolbar >without screwing up your sequences...Doug > >I am trying to enter a date range into a cell on a spreadsheet u --- MUGLO information at <http://www.freewebs.com/muglo> Manage your account options at <//www.freelists.org/cgi-bin/lsg2.cgi>