date/time
Is there a way to set up a cell with a specific date format such as
11/30/2007 in which all the person would havee to type is 11302007 and the rest autofill? Also is there a way to do the same with time and is there a way to have the date and time characters ( "/" ":" ) automatically appear when you begin typing in a cell? |
date/time
Hi
take a look at Chip Pearson's site http://www.cpearson.com/Excel/DateTimeEntry.htm -- Regards Roger Govier "Help with Excel date/time formats" t.com wrote in message ... Is there a way to set up a cell with a specific date format such as 11/30/2007 in which all the person would havee to type is 11302007 and the rest autofill? Also is there a way to do the same with time and is there a way to have the date and time characters ( "/" ":" ) automatically appear when you begin typing in a cell? |
All times are GMT +1. The time now is 01:20 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com