When I enter 0630 it displays 630. How do I keep the 0?
G Gord Dibben Sep 5, 2006 #2 Precede the 0630 with an apostrophe but the text will not be a time. OR enter time as 06:30 Excel is very structured when it comes to entering dates and times. You cannot just enter 060906 and get a valid date. You cannot enter 0630 and return a valid time See Chip Pearson's site for working with dates and times. http://www.cpearson.com/excel/datetime.htm#SerialDates Also see the code involved for entering times without the colon(s) http://www.cpearson.com/excel/DateTimeEntry.htm Gord Dibben MS Excel MVP
Precede the 0630 with an apostrophe but the text will not be a time. OR enter time as 06:30 Excel is very structured when it comes to entering dates and times. You cannot just enter 060906 and get a valid date. You cannot enter 0630 and return a valid time See Chip Pearson's site for working with dates and times. http://www.cpearson.com/excel/datetime.htm#SerialDates Also see the code involved for entering times without the colon(s) http://www.cpearson.com/excel/DateTimeEntry.htm Gord Dibben MS Excel MVP
F Fingerjob Sep 5, 2006 #3 Or you can make a custom format = 0000. When you type 0630 or 630 it will show 0630. But the value in the cell will be 630 Best regards pp Gord Dibben skrev:
Or you can make a custom format = 0000. When you type 0630 or 630 it will show 0630. But the value in the cell will be 630 Best regards pp Gord Dibben skrev:
