how do i enter a date quickly without using slashes or dashes?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i want to enter a date by only using number keys but i want the outcome to
have the slashes in it i.e. 060204 --> 06/02/04. just like if you enter a
currency like 602.04 it comes out like $602.04 and you don't have to add the
$ because of how the cell is formatted.
 
You must log in or register to reply here.

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 2003 keeps on changing the date that i entered. HELP PLEASE 1
Entering dates without having to use slashes? 2
Remove slash charaters from a date field 3
To enter a date 5
Date Format 2
Can I enter a date without using the / or hyphen? 2
Macro - insert slashes into a cell 1
Can I indicate zero with a slash? 3

Back
Top