Masking?

[Michael]

I would like to do some data entry in a spread sheet.


First example
I have a date cell and it is using the standard of 02/07/06 .
I want to make it so that when I start the cell I see the slashes and I
don't need to put them in and it goes from the 02 to the 07 without me
having to manually putting the slashes in.

Second example
I have a time cell that uses 09:28. I want to be able to put in 0928
and it separate it out without me having to put the : in manually.

Are these two examples what masking is for? This is probably in the
help somewhere and I am just not seeing it.

Thanks for your help

 

[Dave Peterson]

Excel doesn't support this kind of masking.

But Chip Pearson has some code you may like. You enter the digits and the code
converts it to time/date.

http://cpearson.com/excel/DateTimeEntry.htm

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

If you want to read more about these kinds of events:

Chip Pearson's site:
http://www.cpearson.com/excel/events.htm

David McRitchie's site:
http://www.mvps.org/dmcritchie/excel/event.htm