Date format

C

Cathy C

I want to format a column of cells so that when 012208 is entered with the
numeric keypad, 01/22/2008 appears in the cell. So far, I'm getting
6/3/1933.

Thanks,
Cathy
 
C

Cathy C

I realize that. That's why I posted in this forum hoping there was some
function whereby I could accomplish this task.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel does not accept text format! 0
Problem formatting dates from CSV file 2
Insert Index into a Table 1
Function or Sub to help with text string 5
How to get largest date from a Vlookup 1
separating date and time 5
countifs Function not giving desired result with date criteria 2
Help with time function 7

Top