input mask in excel

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

Guest

Hi,
I need to make input mask for date cell like MS-Access I mean when user
enter date comes to him date mask like __/__/____ when he write on that field
comes 04/__/____ until finsh 04/12/2005. is it posible in excel???
 
Not unless you use a variable behind the scenes to hold the value and
replace it with whatever 'mask' you decide. In other words it can be
done, but it is not native to basic Excel functionality.
 
Are you trying to do this in order to make it easier to enter a date in
a cell? I mean it is kind of a pain in the butt to have to enter all
of the "/"'s in between the numbers. If that is the case you could
create a form that pops up using a calendar control to enter the date
instead... I have done this and it works very nicely.
 
Hi,
Not exactly what I need. Exactly I need the "/' appers to me in editing mode
of that date cell. If you know about access named "Input mask" for date feild
proprties?
 
Yes, I am familiar with input masks. What I don't understand is why
you need this done that way? Are you transferring the data between
Excel and Access? If that is the case, you could perhaps try using a
custom format like this one...##"/"##"/"## Now if you enter something
like 011005 which would be valid in an Access enviroment, the cell will
still display it as 01/10/05. Hopefully that will do. If not, please
explain Why you need this and maybe I can find some sort of workaround
for you. If you don't know how to format...just check out the help on
custom formats.
 
Back
Top