Hello, I have questions if it is possible to do.
So, I want to type date and wonder if it is possible when I will start typing after entering days slash automatically then months slash automatically and year sorry for my bad explanation but I would like to do something as online filling forms has when you are registering something
Last edited by AliGW; 11-03-2016 at 09:46 AM. Reason: Mod asked to edit title
Is this in a Userform or a cell?
If someone has helped you then please add to their Reputation
cell, want to try this in empty worksheet and then use in my table
How will excel know which month you want? Is it the current month and year?
How many cells are involved?
You could get "auto finish" to kick in, but it would require a macro attached to the cell so that when you type the day, the month and year will appear.
Regards,
David
Please take a moment to re-read forum rule #1 and then amend your thread title to something that better explains your problem. Thanks!
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
What I am trying to do is that make just friendly entry so something like that: cell dd/mm/yy was already in that form and you just type e.g. 14 01 15 and it would display 14/01/15 and I want that during typing was shown slashes want to know if that is possible and if so , how?Originally Posted by David A Coop
@Stolba - you have been asked to amend your thread title. This is not optional.
I have adjusted the thread title at the OP's request.
Last edited by AliGW; 11-03-2016 at 09:46 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks