Hi
You can format cell as DD-Mmm- or
you can use formula =text(ref,"DD-Mmm-) where ref is your reference
cell.
Thanks
On Thu, Mar 27, 2014 at 4:52 PM, Neeraj Chauhan
wrote:
> Dear experts,
>
>
>
> We have given below date format how to convert right format of date like
> 13-Jan-2014
Dear experts,
We have given below date format how to convert right format of date like
13-Jan-2014
TT Modified Date & Time
13/01/2014
15/01/2014 19:51
2-Nov-14
1-Jun-14
2-Nov-14
15/01/2014 19:57
1-Jun-14
13/01/2014 17:10
15/01/2014 19:47
18/01/2014 15:44
From:
i have sent you an attachement on your email id as i am unable to
attached the file here...
Nishant
On Jun 4, 8:02 am, Ankit Mehra wrote:
> Hi Paul,
>
> Let me answer your questions one by one..
>
> 1. All the data for validation, either for col A or for col B is kept in a
> sheet. This sheet i
We have to be careful in "assuming" that the terminology you are using
means the same for us as it does for you.
To ME, what you said is that you want to select one of the cells in Column A
and have a list of data in column B to change.
there are many, many questions that arise.
Where do you get