Assign Values

Posted by Alex on January 21, 2002 8:48 AM

I want to assign a value in column A for each record in the selected area based on the value in column E. It's based on dates. So if the value in column E is 1/01 - 1/31 then the value in column A should be "Jan"
"Feb" for February (2/01-2/28), "Mar" for March (3/01-3/31), so on and so forth. Could I do this with a macro?

Thanks

Posted by Shams on January 21, 2002 9:25 AM

Try the following in Column A :

=Text(E1,"mmm")

Posted by Alex on January 21, 2002 9:33 AM

Perfect!! Thanks!!