Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Validation
0 views
Skip to first unread message
Panchi
Dec 30, 2009, 8:46:03 AM12/30/09
to
How can I limit input of A1 to a specific date format i.e. dd.mm.yy
From cell A1, I would like to extract the month and display as mmm in cell A2
Thanks
Dave Peterson
Dec 30, 2009, 9:59:09 AM12/30/09
to
You could format the cell the way you want and use data|validation (in xl2003
menus) to restrict the entry to a date.
menus) to restrict the entry to a date.
Then in B1, you could use a formula:
=if(a1="","",text(a1,"mmm"))
Be aware that data|validation is easily broken (copy|paste will crush it). But
it should work if the user is typing something.
ps. The user will be able to type the date the way they like and the formatting
will show it to you as you like.
Personally, I'd use an unambiguous format like: dd-mmm-yyyy
--
Dave Peterson
Panchi
Dec 30, 2009, 10:52:01 AM12/30/09
to
Hi Dave,
I have used the formula as you have advised but the cell shows the whole
date as in A1 and not the month itself.
Panchi
"Dave Peterson" wrote:
> .
>
Panchi
Dec 30, 2009, 11:04:06 AM12/30/09
to
Its OK Dave... its work perfect........ I had a validation set on the cell
but when i removed it, your formula worked perfect. Thanks
but when i removed it, your formula worked perfect. Thanks
"Dave Peterson" wrote:
> .
>
0 new messages