Dont know if you can do that. If you have the cell formatted as a date, it
will think the date you're talking about is 10101 and give you 8/27/27.
How about you save yourself a keystroke or two, and don't enter 0s when they
directly precede a number? You can use your energy to press "/" instead, and
you wont have to worry about this.
Altneratively, what you could do, is format cells as text, enter 010101,
then look at the first 2 numbers to determine the month, the 3rd and 4th to
determine the day, and the 5th and 6th to determine the year, then create a
date that way.
=LEFT(F22,2)&"/"&MID(F22,3,2)&"/"&RIGHT(F22,2)
ME said:
i would like to be able to type in a 6 digit no. eg 010101 and it be
changed to this 01/01/01 is this possible and if so could >someone explain
it to me simply thankyou
