Is is possible to enter time in a spreadsheet without using a semi-colon?
A Access Trainee Apr 7, 2009 #1 Is is possible to enter time in a spreadsheet without using a semi-colon?
G Gord Dibben Apr 7, 2009 #3 1. enter without a colon then use a helper cell to convert to time 2. Use event code to convert as you enter. See Chip Pearson's site for code. http://www.cpearson.com/excel/DateTimeEntry.htm Gord Dibben MS Excel MVP
1. enter without a colon then use a helper cell to convert to time 2. Use event code to convert as you enter. See Chip Pearson's site for code. http://www.cpearson.com/excel/DateTimeEntry.htm Gord Dibben MS Excel MVP
