Tech Support Guy banner
Status
Not open for further replies.

Date Format in Excel

1K views 5 replies 4 participants last post by  OBP 
#1 ·
What format do I use when I type 010106 and want it to appear as 01/01/06?
Thanks.
 
#2 ·
Hi there,

That will probably show up as just a number and wont' be interpreted as a date. The format you want to use is:

dd/mm/yy

To apply, goto Format | Cells (or Ctrl + 1) | Number (tab), choose the format in the Date list or apply your own custom format with the format supplied above.

HTH
 
#4 ·
You can use the - sign if you want, but you need something in there.

Now this can be done, without adding any additional characters, with VBA if you like. But it would seem such a larger undertaking than just typing in a couple extra characters on entry.
 
#5 ·
cb13h said:
Thank you. You are right. The number wasn't recognized as a date. I guess it can't be done without typing the "/".
You guess correct. However, if you apply Zack's custom format suggestion in advance, you can then get away with typing:

1/1

for 01/01/06, which is much quicker.
 
Status
Not open for further replies.
You have insufficient privileges to reply here.
Top